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

0 vote346 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote346 views1 answer
Postgresql in vs any performance
SQL
0 vote345 views1 answer
Connecting to my cloud sql server with c#
SQL
4 votes351 views3 answers
Rename table column postgresql
SQL
0 vote343 views1 answer
Django mssql backend
SQL
0 vote339 views1 answer
Mysql count unique in group statement
SQL
0 vote336 views1 answer
Mysql select all table that have field names
SQL
0 vote332 views2 answers
Postgresql get last day of month
SQL
4 votes325 views2 answers
Tables in sql
SQL
-1 vote348 views1 answer
Module operator in oracle sql
SQL