MySQL query finding values in a comma separated string

by

The classic way would be to add commas to the left and right:

select * from shirts where CONCAT(',', colors, ',') like '%,1,%'

But find_in_set also works:

select * from shirts where find_in_set('1',colors) <> 0

More Related Contents:

  1. In MySQL queries, why use join instead of where?
  2. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  3. Can table columns with a Foreign Key be NULL?
  4. MySQL not using indexes with WHERE IN clause?
  5. MySQL dump by query
  6. single fixed table with multiple columns vs flexible abstract tables
  7. How many rows in a database are TOO MANY?
  8. SQLite – ORDER BY RAND()
  9. SQL – How to transpose?
  10. Which SQL query is better, MATCH AGAINST or LIKE?
  11. MySQL equivalent of DECODE function in Oracle
  12. How to delete Duplicates in MySQL table
  13. Best database field type for a URL
  14. Query that ignore the spaces
  15. How to Optimize Queries in a Database – The Basics
  16. MySQL – how to front pad zip code with “0”?
  17. Create date from day, month, year fields in MySQL
  18. Find rows that have the same value on a column in MySQL
  19. what is the difference between GROUP BY and ORDER BY in sql
  20. How do I list all the columns in a table?
  21. Two single-column indexes vs one two-column index in MySQL?
  22. VARCHAR as foreign key/primary key in database good or bad?
  23. How to find all IDs of children recursively?
  24. How to select the nth row in a SQL database table?
  25. Simple way to calculate median with MySQL
  26. MySQL “NOT IN” query
  27. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  28. What is the purpose of constraint naming
  29. Multiple Ranks in one table
  30. Comma separated values in a database field

Leave a Comment