/SQL/Mysql select where field like in list

Mysql select where field like in list

Mysql select where field like in list

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

SELECT * from mytable where field REGEXP 'I|am|looking|for|these|strings';

0

Source: stackoverflow.com

Similar codes

8 votes187 views3 answers
Mysql alter table add index
SQL
2 votes199 views1 answer
How to get weekday from old date in sql
SQL
0 vote199 views1 answer
Mysql command line ubuntu
SQL
-1 vote205 views1 answer
Concat two columns in sql server
SQL
15 votes199 views3 answers
Mysql update add to existing value
SQL
1 vote250 views1 answer
Mysql stop password policy
SQL
0 vote183 views1 answer
Sql delete where x or y or z
SQL
0 vote192 views1 answer
How much table store postgres
SQL
0 vote212 views1 answer
Top 3 salary in sql
SQL
1 vote211 views1 answer
Replace all numbers in mysql
SQL

Share