/SQL/T_sql contains

T_sql contains

Sql where contains

SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
   OR column1 LIKE '%word2%'
   OR column1 LIKE '%word3%'

17

Source: stackoverflow.com

T_sql contains

SELECT * FROM table WHERE Contains(Column, "test");

0

Source: stackoverflow.com

Similar codes

1 vote197 views1 answer
Not exists mysql
SQL
9 votes213 views4 answers
Postgresql export database
SQL
0 vote198 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote201 views1 answer
How to check the port of mysql installation in mac
SQL
12 votes196 views3 answers
Install sqlite driver ubuntu
SQL
0 vote201 views1 answer
Sql server select record with max id
SQL
0 vote204 views1 answer
Docker export psql sql
SQL
2 votes213 views1 answer
Postgresql create table as select
SQL
0 vote207 views1 answer
Oracle gather table statistics
SQL
0 vote199 views1 answer
How to add boolean column in postgresql
SQL

Share