On Thu, May 04, 2000 at 12:14:12PM +0100, Peter McEvoy mentioned:
> Not sure how much SQL MySQL supports but you could try:
>> update mytable
> set fullname = replace(fullname, ':');
>> (this will replace every ':' with nothing, with extended args to replace,
> you can replace : with somthing else. Note that translate function won't
> work this way)
>> Then repeat for all dodgy characters (unfortunately, regexp support is not
> that great in SQL so you can't do
> replace(fullname, /[^A-Za-z0-9]*/)
>> but for a quick fix, this might help..
Alas, there are 70 odd chars that are allowed in email addresses, and 220
that aren't...
Kate
--
"The fool must be beaten with a stick, for an intelligent person
the merest hint is sufficient" -- Zen Master Greg
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
