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 solution). See: http://dev.mysql.com/doc/refman/5.0/en/adding-functions.html Fan, Wellington wrote: > 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
