MySQL Forums
Forum List  »  Newbie

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).,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

Written By
Remove non-alphanumeric characters
June 28, 2010 06:35AM

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.