Sql compare strings

SELECT * FROM table WHERE Column = 'test';			-- can use index
SELECT * FROM table WHERE Column LIKE '%test%';		-- can't use index
SELECT * FROM table WHERE CONTAINS(Column, 'test'); -- faster with full text index

Similar codes

1 vote185 views2 answers
Check if word is in column sql
SQL
0 vote222 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote169 views1 answer
How to get initials in sql
SQL
1 vote126 views1 answer
Postgres kill pid
SQL
0 vote188 views1 answer
Oracle lower in where clause
SQL
3 votes162 views1 answer
Sql cast to integer
SQL
0 vote167 views1 answer
Database xml sql
SQL
2 votes166 views2 answers
Get all tables using like
SQL
0 vote121 views1 answer
Get last run query sql server
SQL
2 votes159 views1 answer
Sql server find table name
SQL