SQL select everything in an array

Question

My homework has a problem for example there is a category array  cat array  1   4   5   7    now i need to select products from db based on the category that is  SELECT   FROM products WHERE catid  1  SELECT   FROM products WHERE catid  4  SELECT   FROM products WHERE catid  5  SELECT   FROM products WHERE catid  7    Is it possible to do this in a single query  as the final results of the four queries will be combined

User · Accepted Answer

SELECT   FROM products WHERE catid IN   1    2    3    4

User · Answer

SQL Part      i 0  while   i lt length  cat -1        SQL Part   cat i          SQL Part  SQL Part  cat  i 1        SQL  SELECT   FROM products WHERE catid IN    SQL Part    It s more generic and will fit for any array

User · Answer

array of  ids that you need to select  ids   array  1    2    3    4    5    6    7    8        create sql part for IN condition by imploding comma after each id  in         implode       ids            create sql  sql    SELECT   FROM products WHERE catid IN      in      see what you get var dump  sql     Update   a short version and update missing comma    ids   array  1   2   3   4     sql    SELECT   FROM products WHERE catid IN      implode       ids

[sql] SQL select everything in an array

Examples related to sql

Examples related to select