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 vote314 views1 answer
Denormalise SQL command
SQL
1 vote370 views2 answers
This month mysql where
SQL
0 vote333 views1 answer
Postgres drop type
SQL
1 vote361 views1 answer
How to see logical reads in sql server
SQL
1 vote333 views1 answer
Mysql decimal allow negative values?
SQL
0 vote334 views1 answer
Can we rollback in sql
SQL
2 votes362 views1 answer
Create mysql user on all hosts
SQL
0 vote349 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
22 votes315 views2 answers
Mysql show all tables
SQL
0 vote310 views1 answer
Rabbitmq service not starting
SQL