/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

0 vote364 views1 answer
How to know if table in rigt or left in sql
SQL
1 vote358 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote364 views3 answers
How to increase size of column in sql
SQL
4 votes343 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote362 views1 answer
Postgres clear table
SQL
0 vote357 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
1 vote358 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote365 views1 answer
Mysql a from on this page has
SQL
2 votes368 views1 answer
How to delete columns in sql
SQL
0 vote331 views1 answer
Ms Sql set us timezone
SQL

Share