/SQL/Sql where part of string match

Sql where part of string match

Sql where part of string match

select * from docs where DOC_NAME like '%virus%spyware%'
-- OR
select * from docs where DOC_NAME like '%virus%' or DOC_NAME like '%spyware%'

0

Similar codes

2 votes234 views1 answer
Tsql copy table
SQL
3 votes263 views3 answers
1396(hy00) mysql error
SQL
2 votes237 views1 answer
Apex execute batch job
SQL
1 vote274 views1 answer
UseSqlServer no definition
SQL
6 votes254 views2 answers
Psql load dump
SQL
0 vote227 views1 answer
Postgre admin slow
SQL
2 votes252 views1 answer
Oracle generated column
SQL
3 votes227 views1 answer
Sql several or
SQL
0 vote250 views1 answer
Create table database in psql
SQL
0 vote232 views1 answer
Mysql date time string format python
SQL

Share