/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

0 vote212 views1 answer
How to select even id in sql
SQL
0 vote192 views1 answer
Update top 100 sql
SQL
6 votes201 views1 answer
Oracle pl sql source
SQL
0 vote287 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote197 views1 answer
Find invalid datetime field
SQL
0 vote189 views1 answer
Database springboot
SQL
26 votes197 views2 answers
What is the sql statement that finds duplicate usernames
SQL
12 votes189 views2 answers
Delete entries in postgresql
SQL
0 vote235 views1 answer
Combine 2 columns search query mysql
SQL
0 vote206 views1 answer
Raiserror with nowait
SQL

Share