/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 vote174 views1 answer
Redudancy in SQL
SQL
0 vote170 views1 answer
Is not null postgresql
SQL
0 vote170 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
1 vote251 views1 answer
Connect to mysql database ubuntu
SQL
2 votes212 views2 answers
Mysql write into table
SQL
10 votes175 views4 answers
Primary key sql
SQL
0 vote178 views1 answer
Query by column for substring sql
SQL
4 votes303 views1 answer
What are the data types
SQL
0 vote218 views1 answer
Postgresql select fast check no rows
SQL
13 votes166 views2 answers
Oracle select into and inner join
SQL

Share