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 vote304 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
1 vote300 views1 answer
Sql oracle update multiple rows
SQL
0 vote350 views1 answer
How to change mysql root password in windows 10
SQL
2 votes354 views1 answer
Oracle find constraints referencing a table
SQL
0 vote347 views1 answer
Local pg_sql to heroku pg_sql
SQL
7 votes337 views2 answers
Where keyword sql
SQL
0 vote314 views1 answer
Running query in redshift
SQL
0 vote318 views2 answers
Tsql row number
SQL
0 vote304 views1 answer
Jooq replace
SQL
0 vote384 views1 answer
Oracle calculate statistics on partition
SQL