/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 vote240 views1 answer
Changer un mot de passe mysql
SQL
0 vote287 views1 answer
Modifier une valeur sql
SQL
0 vote272 views1 answer
Sql convert unix time to date
SQL
1 vote238 views1 answer
Show indices in mysql table
SQL
0 vote461 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote247 views1 answer
Mysql show foreign keys column
SQL
0 vote243 views1 answer
SQL Server format datetime
SQL
0 vote251 views1 answer
Update one column from another column in same table
SQL
0 vote274 views1 answer
Comparing with today and yesterday record in sql query
SQL
25 votes285 views1 answer
How to update an attribute in MySQL
SQL

Share