mysql check if numbers are in a comma separated list

by

This one also works:

SELECT * FROM table WHERE 3 IN (NUMBERS) AND 15 IN (NUMBERS)

using the IN will look into a comma separated string eg. these two

WHERE banana IN ('apple', 'banana', 'coconut')
WHERE 3 IN (2,3,6,8,90)

Info found on this page:

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. What is the error “Every derived table must have its own alias” in MySQL?
  3. Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
  4. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. How to grant remote access permissions to mysql server for user?
  7. Generating a series of dates [duplicate]
  8. Oracle Database Link – MySQL Equivalent?
  9. How to escape single quotes in MySQL
  10. MySQL comparison with null value
  11. Why is the estimated rows count very different in phpmyadmin results?
  12. Slow query when using ORDER BY
  13. How to import XML file into MySQL database table using XML_LOAD(); function
  14. Unique constraint that allows empty values in MySQL
  15. Matching all values in IN clause
  16. INTERSECT in MySQL
  17. Having both a Created and Last Updated timestamp columns in MySQL 4.0
  18. MySQL select with CONCAT condition
  19. What does SQL clause “GROUP BY 1” mean?
  20. Bogus foreign key constraint fail
  21. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  22. Syntax error when using except in a query
  23. Easiest way to copy a table from one database to another?
  24. sql like operator on integer
  25. The best way to remove value from SET field?
  26. How to import large sql file in phpmyadmin
  27. How to figure out size of Indexes in MySQL
  28. Equivalent of MSSQL IDENTITY Column in MySQL
  29. #1060 – Duplicate column name ‘id’
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment