Remove all non-alpha characters?

[Fan, Wellington]

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? MySQL 3.23, BTW.

--
Wellington

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]