This is what I am using:
Quote:
|
SELECT * FROM Recipe WHERE Category REGEXP '/(?=.*?(seafood))(?=.*?(lunch))/is' ORDER BY RAND() LIMIT 5;");
|
I want it to display the results for rows that contain both the words (any cAsE) 'seafood' AND 'lunch' in the Category column, it doesnt like my expression though for some reason, any pointers please?
I was under the impression i could use the following to do what I wanted:
Quote:
|
SELECT * FROM Recipe WHERE Category REGEXP '(?=.*seafood)(?=.*lunch)' ORDER BY RAND() LIMIT 5;");
|
But it doesnt seem to like that either
