MySQL LIKE IN()?

A REGEXP might be more efficient, but you’d have to benchmark it to be sure, e.g.

SELECT * from fiberbox where field REGEXP '1740|1938|1940';

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Unknown column in ‘field list’ error on MySQL Update query
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. MySQL – Operand should contain 1 column(s)
  5. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. MySQL create table if not exists and insert record only if table was created
  8. How do I use properly CASE..WHEN in MySQL
  9. How can I do a FULL OUTER JOIN in MySQL?
  10. MySQL query String contains
  11. What’s the difference between VARCHAR and CHAR?
  12. Case statement in MySQL
  13. How to declare a variable in MySQL?
  14. MySQL Cannot Add Foreign Key Constraint
  15. How to split the name string in mysql?
  16. How do I import an SQL file using the command line in MySQL?
  17. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  18. mysql Foreign key constraint is incorrectly formed error
  19. MySQL: Invalid use of group function
  20. How can I return pivot table output in MySQL?
  21. Compare dates in MySQL
  22. MySQL “WITH” clause
  23. MySQL Multiple Joins in one query?
  24. Error Code: 2013. Lost connection to MySQL server during query
  25. MySQL syntax for Join Update
  26. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  27. how to drop partition without dropping data in MySQL?
  28. MySQL combine two columns into one column
  29. Simple way to calculate median with MySQL
  30. Error 1046 No database Selected, how to resolve?
  31. MySQL Error 1264: out of range value for column
  32. Remove duplicate rows in MySQL
  33. How to SUM and SUBTRACT using SQL?
  34. Cast from VARCHAR to INT – MySQL
  35. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  36. How do you force mysql LIKE to be case sensitive?
  37. MySQL – UPDATE multiple rows with different values in one query
  38. How to create a MySQL hierarchical recursive query?
  39. ERROR 1148: The used command is not allowed with this MySQL version
  40. Insert into a MySQL table or update if exists
  41. How to round down to nearest integer in MySQL?
  42. MySQL starts with searching issue
  43. Query to convert from datetime to date mysql
  44. Is it possible to GROUP BY multiple columns using MySQL?
  45. MySQL error: key specification without a key length
  46. Best way to test if a row exists in a MySQL table
  47. Check if MySQL table exists without using “select from” syntax?
  48. MySQL equivalent of DECODE function in Oracle
  49. mysql update column with value from another table
  50. The used SELECT statements have a different number of columns
  51. How to delete from multiple tables in MySQL?
  52. MySQL: Can’t create table (errno: 150)
  53. How to copy a row and insert in same table with a autoincrement field in MySQL?
  54. Join vs. sub-query
  55. Alternative to except in MySQL
  56. Equivalent of explode() to work with strings in MySQL
  57. ROW_NUMBER() in MySQ
  58. MySQL OPTIMIZE all tables?
  59. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  60. MySQL – Get row number on select
  61. MySQL error: Unknown column in ‘where clause’
  62. How to truncate the text returned for a column in a MySQL query
  63. Using union and order by clause in mysql
  64. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  65. Using group by on multiple columns
  66. Efficiently convert rows to columns in sql server
  67. Nested select statement in SQL Server
  68. Sql Server equivalent of a COUNTIF aggregate function
  69. SQL – HAVING vs. WHERE
  70. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  71. How to SUM two fields within an SQL query
  72. DateTime2 vs DateTime in SQL Server
  73. Difference between numeric, float and decimal in SQL Server
  74. How can I do ‘insert if not exists’ in MySQL?
  75. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  76. How can I prevent SQL injection in PHP?
  77. How can I do ‘insert if not exists’ in MySQL?
  78. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  79. postgresql: error duplicate key value violates unique constraint
  80. Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
  81. Convert timestamp to date in Oracle SQL
  82. Update statement with inner join on Oracle
  83. #1062 – Duplicate entry for key ‘PRIMARY’
  84. INSERT VALUES WHERE NOT EXISTS
  85. Difference between `load data inpath ` and `location` in hive?
  86. SQLite string contains other string query
  87. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  88. Inserting Post Meta From SQL
  89. WordPress SQL LIKE request doesn’t work for fields with special symbols
  90. How can I add a new row in a separate database when someone registers via WordPress?
  91. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  92. WP MultiSite: Can’t select database error after changing to new domain
  93. $wpdb->get_var – What value is returned when zero records are found?
  94. Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
  95. Database SQL query error
  96. Inserting other fields to existing registration form in a WordPress theme
  97. Organising and completing posts (mark as read and hide)
  98. can’t delete a row from post_meta table
  99. SQL error on restoring database
  100. Creating a “forum” – showing last post or last commented post

Leave a Comment