Write it better... SQL suggestions

[fabiuz]

Hallo,

is there any way to write it better in MySQL ?

SELECT id,name
FROM autors
WHERE REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LCASE(name), ' ', ''), '.', ''), '\'', ''), '(the)', ''), '/', ''), '&', '') LIKE 'string to be cleaned from / (the) etc.'

I need to clean a string into a field in order to make one search more into db...

Thank you !!

[jweissig]

hi,

I guess if you wanted to insert or select data you can use the same method. I would build a function which cleans my data.

You should build a function in PHP or Perl which takes a string and runs some regex’s and then returns the cleaned string to the database.

I know this is a little more over head as you would have to select the data, then update the data. But this would be much more readable.

Thanks
- justin