Using SQL LIKE and IN together

by

How about using a substring with IN.

select * from tablename where substring(column,1,4) IN ('M510','M615','M515','M612')

More Related Contents:

  1. Error related to only_full_group_by when executing a query in MySql
  2. How to declare a variable in MySQL?
  3. Can you split/explode a field in a MySQL query?
  4. MySQL Cannot Add Foreign Key Constraint
  5. Grouping into interval of 5 minutes within a time range
  6. SQL counting all rows instead of counting individual rows
  7. MySQL – ERROR 1045 – Access denied
  8. Remote Connections Mysql Ubuntu
  9. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  10. Difference between float and decimal data type
  11. Parse date in MySQL
  12. In MySQL, should I quote numbers or not?
  13. MySQL add days to a date
  14. How can I loop through all rows of a table? (MySQL)
  15. MySQL incorrect key file for tmp table when making multiple joins
  16. How to cast DATETIME as a DATE in mysql?
  17. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  18. Does the order of conditions in a WHERE clause affect MySQL performance?
  19. Difference between these two joining table approaches?
  20. Get total number of rows when using LIMIT? [duplicate]
  21. MySQL query, MAX() + GROUP BY
  22. Convert JSON array in MySQL to rows
  23. Table is specified twice, both as a target for ‘UPDATE’ and as a separate source for data in mysql
  24. MySQL export into outfile : CSV escaping chars
  25. Simple Random Samples from a MySQL Sql database
  26. MySQL Select minimum/maximum among two (or more) given values
  27. MySQL: Many tables or many databases?
  28. Select only last value using group by at mysql
  29. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  30. Dump only the data with mysqldump without any table information?

Leave a Comment