Hello.
I haven't said that this is the most effective solution, however, in my
opinion it should work :)
Fan, Wellington wrote:
Gleb,
Thanks; using REPLACE(), as I understand it, would require me to list ALL
non-alpha characters, and assuming just ASCII characters, approx (127 -
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(
Hello List-people ,
I am looking to remove all non-alphanumeric characters from a column:
UPDATE
mytable
SET
mycolumn = REMOVE_NON_ALPHAS(mycolumn)
WHERE
mycolumn REGEXP '[^[:alpha:]]'
where REMOVE_NON_ALPHAS() is a fictional function.
How can I achieve this result?
Hello.
You should think about using REPLACE function. See:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
BTW, 3.23 is a very old version. If you switch to 5.0 you'll be able to
use all power of stored functions. Think about UDFs as well (but it
could be a very heavy