REGEXP not working right?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Publisher Bucks
    Confirmed User
    • Oct 2018
    • 1339
    #1

    Tech REGEXP not working right?

    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
    Extreme Link List - v1.0
    Tags: None
    • faperoni
      Confirmed User
      • Feb 2015
      • 220
      #2
      Maybe LIKE works better for you

      Code:
      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

      Code:
      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

        Comment

        • k0nr4d
          Confirmed User
          • Aug 2006
          • 9231
          #3
          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.
          Mechanical Bunny Media
          Mechbunny Tube Script | Mechbunny Webcam Aggregator Script | Custom Web Development

            Comment

            • sarettah
              see you later, I'm gone
              • Oct 2002
              • 14336
              #4
              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.

              .
              All cookies cleared!

                Comment

                Previous template Next
                Working...