FIND_IN_SET with multiple value [duplicate]

by

FIND_IN_SET() can only be used to search for a single value in a comma-separated list, it doesn’t work with two lists.

You’ll need to call it separately for each value.

SELECT * FROM tablename
WHERE FIND_IN_SET('12', category_id) OR FIND_IN_SET('13', category_id) OR FIND_IN_SET('15', category_id)

It would be better if you normalized your schema instead of using comma-separated lists. If you create a many-to-many table with the category IDs, you could do:

SELECT t1.*
FROM tablename AS t1
JOIN item_categories AS c ON t1.id = c.table_id
WHERE c.category_id IN (12, 13, 15)

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  3. How to select the nth row in a SQL database table?
  4. 1052: Column ‘id’ in field list is ambiguous
  5. How to do a batch insert in MySQL
  6. Count the occurrences of DISTINCT values
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. Storing JSON in database vs. having a new column for each key
  9. How do I restore a dump file from mysqldump?
  10. Cast int to varchar
  11. Import SQL file into mysql
  12. How to change the default port of mysql from 3306 to 3360
  13. Does mysql have the equivalent of Oracle’s “analytic functions”?
  14. How to skip certain database tables with mysqldump?
  15. “where 1=1” statement [duplicate]
  16. How to set a MySQL row to READ-ONLY?
  17. MySQL: LAST_INSERT_ID() returns 0
  18. Using reserved words in column names
  19. Calculating a Moving Average MySQL?
  20. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  21. How to insert a file in MySQL database?
  22. Strings as Primary Keys in MYSQL Database [closed]
  23. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  24. What is the difference between SQL and MySQL? [closed]
  25. Selecting distinct 2 columns combination in mysql
  26. How to store a one to many relation in MySQL database?
  27. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  28. MySQL: Computed Column
  29. Optimistic locking in MySQL
  30. mySQL SELECT upcoming birthdays

Leave a Comment