MySQL - How to select rows where value is in array

Question

Ok  normally I know you would do something like this if you knew the array values  1 2 3 in this case    SELECT   WHERE id IN  1 2 3    But I don t know the array value  I just know the value I want to find is  stored  in the array   SELECT   WHERE 3 IN  ids     Where  ids  is an array of values 1 2 3   Which doesn t work  Is there another way to do this

User · Answer

If you use the FIND IN SET function   FIND IN SET a  columnname  yields all the records that have  a  in them  alone or with others   AND   FIND IN SET columnname  a  yields only the records that have  a  in them alone  NOT the ones with the others  So if record1 is  a b c  and record2 is  a    FIND IN SET columnname  a  yields only record2 whereas FIND IN SET a  columnname  yields both records

User · Answer

By the time the query gets to SQL you have to have already expanded the list  The easy way of doing this  if you re using IDs from some internal  trusted data source  where you can be 100  certain they re integers  e g   if you selected them from your database earlier  is this    sql    SELECT   WHERE id IN      implode       ids           If your data are coming from the user  though  you ll need to ensure you re getting only integer values  perhaps most easily like so    sql    SELECT   WHERE id IN      implode      array map  intval    ids

User · Answer

If the array  element is not integer you can use something like below     skus    array  LDRES10   LDRES12   LDRES11        sample data  if  empty  skus              sql    SELECT   FROM  products  WHERE  prodCode  IN       implode         skus

User · Answer

Use the FIND IN SET function   SELECT t     FROM YOUR TABLE t  WHERE FIND IN SET 3  t ids   gt  0

[php] MySQL - How to select rows where value is in array?

Examples related to php

Examples related to mysql