/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

0 vote223 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote215 views1 answer
How to access to mysql without root
SQL
0 vote235 views1 answer
Sql delete from with relation
SQL
0 vote269 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
36 votes247 views3 answers
Add column in mysq
SQL
0 vote216 views1 answer
Sql query for displaying age from oldest to youngest
SQL
1 vote206 views1 answer
Stored procedure return value
SQL
-1 vote235 views1 answer
How to dump .csv file into mysql
SQL
0 vote229 views1 answer
Exec procedure oracle
SQL
0 vote220 views1 answer
Grant access on table in oracle
SQL

Share