Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
a. good +morning girl -afternoon
b. good +morning -girl <-- this stores inside the DB.
Don't need to say, they won't match because of word "girl". This is exactly what I want.
How do I write a query this do this? I was think of usine REGEXP, but it's hard still because I am matching a target which is a regular expression not a string. Things can get much more complicate when I combine a bunch of "and" and "or" and "not" statements.
Let me just suggest that I would explode() your regular expression, separators being your "and", "or", etc. and other popular statements you may use.
Then, compare each element of your regular with each element of your "master" regular expression by using the similar_text() function.
Am I right? It is just a guess!