MySQL Like multiple values

Question

I have this MySQL query   I have database fields with this contents  sports shopping pool pc games  shopping pool pc games  sports pub swimming  pool  pc  games      Why does this like query does not work  I need the fields with either sports or pub or both   SELECT   FROM table WHERE interests LIKE    sports      pub

User · Answer

Your query should be SELECT   FROM  table  WHERE find in set interests   sports pub   gt 0  What I understand is that you store the interests in one field of your table  which is a misconception  You should definitively have an  interest  table

User · Answer

More work examples   SELECT COUNT email  as count FROM table1 t1  JOIN         SELECT company domains as emailext FROM table2 WHERE company    DELL         t2  ON t1 email LIKE CONCAT      emailext  WHERE t1 event  PC Global Conference     Task was count participants at an event s  with filter if email extension equal to multiple company domains

User · Answer

Like  Alexis Dufrenoy proposed  the query could be   SELECT   FROM  table  WHERE find in set  sports   interests  gt 0 OR find in set  pub   interests  gt 0   More information in the manual

User · Answer

Don t forget to use parenthesis if you use this function after an AND parameter  Like this   WHERE id 123 and interests LIKE   sports   OR interests LIKE   pub

User · Answer

Why not you try REGEXP  Try it like this   SELECT   FROM table WHERE interests REGEXP  sports pub

User · Answer

Faster way of doing this  WHERE interests LIKE   sports   OR interests LIKE   pub    is this   WHERE interests REGEXP  sports pub   Found this solution here  http   forums mysql com read php 10 392332 392950 msg-392950 More about REGEXP here  http   www tutorialspoint com mysql mysql-regexps htm

User · Answer

Or if you need to match only the beginning of words   WHERE interests LIKE  sports   OR interests LIKE  pub     you can use the regexp caret matches   WHERE interests REGEXP   sports  pub    https   www regular-expressions info anchors html

User · Answer

The  a b c  list only works with in  For like  you have to use or   WHERE interests LIKE   sports   OR interests LIKE   pub

User · Answer

You can also use REGEXP s synonym RLIKE as well  For example  SELECT   FROM TABLE NAME WHERE COLNAME RLIKE  REGEX1 REGEX2 REGEX3

[mysql] MySQL Like multiple values

Examples related to mysql

Examples related to sql

Examples related to sql-like