PHP / MYSQL-如何使用IN查询

Question

When i am add new post that time select multiple category and store in database like 48,52 into single field sub_cat_id

I am try to get value using IN but not get properly

SELECT *
FROM tbl_listing 
WHERE status='1' and sub_cat_id IN (52)
ORDER BY tbl_listing.company_name DESC LIMIT 0, 15

I am store value into db like below screenshot

Please help me

Answer 1

If you are passing 48,52 as comma separated numbers as a string to IN then search is not performed correctly. You have to use FIND_IN_SET with column and the CSV value.

SELECT * FROM tbl_listing 
WHERE status='1' 
  and ( FIND_INSET( 48, sub_cat_id ) > 0
        OR FIND_INSET( 52, sub_cat_id ) > 0 )
ORDER BY 
  tbl_listing.company_name DESC 
LIMIT 0, 15

Refer to:

• MySQL: FIND_IN_SET( str, strlist ): Return the index position of the first argument within the second argument