MySQL search in comma list [duplicate]

by

You need the FIND_IN_SET function:

SELECT ... WHERE FIND_IN_SET('1', field)

More Related Contents:

  1. Complex Count in MySQL
  2. How can I fix MySQL error #1064?
  3. Using MySQL with Entity Framework [closed]
  4. Usage of MySQL’s “IF EXISTS”
  5. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  6. Cannot delete or update a parent row: a foreign key constraint fails
  7. How to reset mysql root password?
  8. Using union and order by clause in mysql
  9. Binary Data in MySQL [closed]
  10. Remove HTML tags from record
  11. MySQL COUNT DISTINCT
  12. mysql -> insert into tbl (select from another table) and some default values [duplicate]
  13. Convert MySQL schema to Github Wiki?
  14. mysql select from n last rows
  15. auto increment primary leaving gaps in counting
  16. Install MySQL on Ubuntu without a password prompt
  17. Exporting results of a Mysql query to excel?
  18. Capitalize first letter of each word, in existing table
  19. ALTER TABLE to add a composite primary key
  20. MySQL Removing Some Foreign keys
  21. MySQL – Fetching lowest value
  22. MySQL – How to select data by string length
  23. SQL Order By Count
  24. ColdFusion Parameterizing a Query
  25. How to select the first row for each group in MySQL?
  26. How to alias a field or column in MySQL?
  27. What to do when you need integers larger than 20 digits on mysql?
  28. How to update JSON data type column in MySQL 5.7.10?
  29. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysql.sock’ (2)
  30. mysql: connection refused when trying to connect to localhost using remote IP

Leave a Comment