/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 vote195 views1 answer
How to install Firebird
SQL
0 vote189 views1 answer
Postgres statistics
SQL
-1 vote200 views1 answer
Mysql select count if contains
SQL
8 votes173 views3 answers
Duplicate entry
SQL
9 votes183 views2 answers
Default number in sql
SQL
1 vote326 views3 answers
Uninstall postgresql mac
SQL
2 votes170 views1 answer
Mysql list users on ubuntu
SQL
0 vote193 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote185 views1 answer
Mysql count number of occurrences in a column
SQL
1 vote144 views1 answer
Enable mysql slow query log
SQL

Share