Can I SELECT WHERE list of values IN list of values?

Asked May 12 '19 at 20:23

Active May 12 '19 at 20:30

Viewed 31 times

it passed some time since I wrote queries and I'm in a pickle.

I have this code:

   SELECT * FROM `products` WHERE `id_category` IN (" . implode(',', array_map('intval', $categories)) . ") ORDER BY `id` DESC

The problem is that id_category is a VARCHAR like (1,2) or (2,6,8).

Is there a way to select the products ? Thank you in advance!

asked May 12 '19 at 20:23

Theo I.

@JonGuiton That question isn't about a comma-separated list in the column. – Barmar May 12 '19 at 20:29
1

You shouldn't put comma-separated values in a column, you should normalize your schema. – Barmar May 12 '19 at 20:29
Ok @Barmar, you are right. But that may not be his choice. – ryantxr May 12 '19 at 20:30

0 Answers0