Gleb,
Thanks; using REPLACE(), as I understand it, would require me to list ALL
non-alpha characters, and assuming just ASCII characters, approx (127 - 52)
nested calls to REPLACE()...
select
REPLACE(
...REPLACE(
REPLACE(
REPLACE(
text,'~',''),
'!',''),
'@','')
...)
> -----Original Message-----
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
...
> You should think about using REPLACE function. See:
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
> Fan, Wellington wrote:
> > Hello List-people ,
> >
> > I am looking to remove all non-alphanumeric characters from
> a column:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
