MySQL Forums
Forum List  »  InnoDB

Re: regexp problem
Posted by: Roland Bouman
Date: August 03, 2005 07:21AM

REPLACE takes three arguments,
1) the string to operate in
2) the string that is searched for
3) the string to replace it with.

youre second argument is not a string, it's a regular expression matching operation. It will return either TRUE or FALSE of phone matches your regular expression.

BTW, you use * in the REGEXP, as far as I can see, this matches everything, always!

Anyway, that's why it does not work. As for a solution to get it working, I can't think of anything better than to REPLACE each character a to z individually. Which seems rather clumsy, I know. I'm still thinking of a better way...I hope there is one...

Options: ReplyQuote


Subject
Views
Written By
Posted
2930
August 03, 2005 03:04AM
Re: regexp problem
2000
August 03, 2005 07:21AM
2097
August 03, 2005 08:32AM
2640
August 03, 2005 09:08AM


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.