Having trouble while searching in mysql via REGEXP

Question

I am implementing search in my project so I have to search data which will be in any order so I'm following this question. But my query was not working

my php query is

 $cat="(?=.*Women)(?=.*Rings)";
 $sql="select * from tbl_jewellery where categories RLike '$cat';";

when I change regex to Women.*Ring|Ring.*Women It works fine but (?=.*Women)(?=.*Rings) approach is easy and can be used for multiple words just adding them.

Rick James · Accepted Answer · 2017-02-23 23:41:34Z

1

MySQL does not implement (? syntax in REGEXPs. I think MariaDB 10.0.5 does.

For a significant subset of such queries, you could use a FULLTEXT index on that categories with this:

MATCH(categories)
    AGAINST('+women +rings' IN BOOLEAN MODE)

That says both "words" occur, without limitations on order or proximity.

answered Feb 23, 2017 at 23:41

Rick James

144k15 gold badges144 silver badges255 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Having trouble while searching in mysql via REGEXP

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related