/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 vote152 views1 answer
Sql server remove 0 from left
SQL
3 votes141 views1 answer
What is having clause
SQL
0 vote160 views1 answer
Mysql cast null to string
SQL
1 vote159 views1 answer
Snowflake rename column name
SQL
3 votes147 views1 answer
Créer une table sql
SQL
0 vote171 views1 answer
Sql field equals multiple values
SQL
1 vote154 views2 answers
Oracle list partitioned tables
SQL
1 vote151 views1 answer
Sql pick random row
SQL
0 vote138 views1 answer
Sql random decimal
SQL
2 votes152 views1 answer
How to insert string variable into sqlite database
SQL

Share