/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 vote324 views1 answer
Renommer table sql
SQL
2 votes425 views5 answers
Tablespace ORACLE
SQL
0 vote338 views2 answers
How to update the multiple rows in sql
SQL
0 vote335 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
5 votes331 views3 answers
Mysql check if null or empty string
SQL
0 vote355 views1 answer
Oracle temporary table
SQL
2 votes368 views1 answer
Q operator in sql
SQL
1 vote347 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote360 views1 answer
Flexible search query delete table
SQL
1 vote332 views1 answer
Neo4j display all nodes and relationships
SQL

Share