Skip navigation links

MySQL Forums :: Newbie :: Remove non-alphanumeric characters


Advanced Search

Remove non-alphanumeric characters
Posted by: Levente Kiss ()
Date: June 28, 2010 06:35AM

Hi all,

I'm looking for a function or something to remove non-alphanumeric characters from fields in a table. I need to run a comparison between fields in 2 tables, but the data in the fields often contains non-alphanumeric characters.
I've been searching this forum (and google) for a few days now, but only found this, which does not help me at all, as when I try to enter this code, mysql complains about some syntax error (which to be honest, I can't find as I'm quite new to mysql).


http://forums.mysql.com/read.php?118,229993,240768#msg-240768


Can you please help me to point out the syntax error, or let me know if you've got a better solution?
Thanks in advance!



Edited 1 time(s). Last edit at 06/28/2010 06:36AM by Levente Kiss.

Options: ReplyQuote


Subject Written By Posted
Remove non-alphanumeric characters Levente Kiss 06/28/2010 06:35AM
Re: Remove non-alphanumeric characters Guelphdad Lake 06/28/2010 08:50AM
Re: Remove non-alphanumeric characters Levente Kiss 06/28/2010 09:29AM
Re: Remove non-alphanumeric characters Guelphdad Lake 06/28/2010 07:00PM
Re: Remove non-alphanumeric characters Levente Kiss 06/29/2010 07:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.