I have a little bit stupid problem because of the database desing. I need to do a string matching comparison with search terms and a value that I get from php script.
So, normaly I would do:
And I think I can't do that stripping in MySQL as there is no "preg_replace" in MySQL.
I had this idea to use a "simulated" query in MySQL, but it seems this is not possible:
But I would like to hear if that "simulated" query did not work cause of some syntax error or if it did not work cause it is not possible at all in MySQL.Code MySQL:
Thanks very much.