Is this SQL good for MySQL ?

Hi,

I need to strip some chars or strings from a varchar field in a table. Is this SQL syntax the best way to do that ?

SELECT filed
FROM table
WHERE REPLACE(REPLACE(REPLACE(REPLACE(filed, ' ', ''), '.', ''), '\'', ''), '(the)', '') LIKE 'cleanmatchword'

As you can see I want to remove spaces, dots, ' and the string (the) ...

Thank you for any help about !

Fabi

Use regexp instead. Read up on in it in the mysql manual.

Mhmm... I don't think that regex can be usefull in this case...

I have a string table field, with words like

Mary have a little lamb

and I need to make queries with the string withou spaces, and other chars... this is why I was using REPLACE string function...

Regex could only limit query input or am I wrong ?