/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 vote254 views1 answer
Kill slow queries mysql
SQL
0 vote224 views2 answers
Drop check constraint in ms sql
SQL
0 vote225 views1 answer
Concatenate columns in table
SQL
2 votes225 views1 answer
Update trigger
SQL
6 votes234 views4 answers
Remove spaces sql server
SQL
0 vote262 views1 answer
Why do we need data structure in sql
SQL
14 votes238 views1 answer
Oracle new column
SQL
18 votes240 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote234 views1 answer
Power bi union columns
SQL
0 vote237 views1 answer
PSQL qith variables
SQL

Share