Tech REGEXP not working right?

[Publisher Bucks]

This is what I am using:

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:

SELECT * FROM Recipe WHERE Category REGEXP '(?=.*seafood)(?=.*lunch)' ORDER BY RAND() LIMIT 5;");

But it doesnt seem to like that either

[faperoni]

Maybe LIKE works better for you

SELECT * FROM Recipe WHERE Category LIKE '%seafood%' OR Category LIKE '%lunch%' ORDER BY RAND() LIMIT 5;");

if the keyword is always at the end of the string you can also use

SELECT * FROM Recipe WHERE Category LIKE '%seafood' OR Category LIKE '%lunch' ORDER BY RAND() LIMIT 5;");

Maybe its better to extract these keywords and put them in a separate table? LIKE (or REGEXP) are "slow".

More pattern matching examples and options:
https://dev.mysql.com/doc/refman/8.0...-matching.html

[k0nr4d]

Faperoni is right, you should consider just using like. REGEXP is hard as fuck and if you are a beginner you simply aren't going to be able to grasp it just yet because people who have been coding for 20 years have issues with it.

[sarettah]

Originally Posted by k0nr4d

Faperoni is right, you should consider just using like. REGEXP is hard as fuck and if you are a beginner you simply aren't going to be able to grasp it just yet because people who have been coding for 20 years have issues with it.

This ^^^^^

I've been slamming code for a hell of a long time and hate the fuck out of reguar expressions.

Like will do it for you most of the time.

.