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';
More Related Contents:
- MySQL: Alternatives to ORDER BY RAND()
- Simple way to calculate median with MySQL
- Unioning two tables with different number of columns
- NULL in MySQL (Performance & Storage)
- MySQL function to find the number of working days between two dates
- MySQL Trigger to prevent INSERT under certain conditions
- MySQL “NOT IN” query
- Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
- Importance of varchar length in MySQL table
- mySQL :: insert into table, data from another table?
- Return 0 if field is null in MySQL
- single fixed table with multiple columns vs flexible abstract tables
- MySQL “between” clause not inclusive?
- MySQL syntax for Join Update
- SQL – How to transpose?
- SQL SELECT to get the first N positive integers
- Sorting string column containing numbers in SQL?
- How to Optimize Queries in a Database – The Basics
- Multiple Ranks in one table
- Any way to achieve fulltext-like search on InnoDB
- The difference between ‘AND’ and ‘&&’ in SQL
- How can I make an average of dates in MySQL?
- What is the best way to generate ranks in MYSQL?
- What does collation mean?
- What’s the correct name for an “association table” (a many-to-many relationship) [closed]
- MySQL: Count records from one table and then update another
- COUNT(id) vs. COUNT(*) in MySQL
- sql pulling a row for next or previous row of a current row
- Row Rank in a MySQL View
- Select Rows with Maximum Column Value group by Another Column