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

2 votes276 views4 answers
How to find 2nd highest salary in mysql
SQL
1 vote298 views1 answer
How to test for sql injection
SQL
0 vote252 views2 answers
Sql update from two different database
SQL
0 vote295 views1 answer
Into operator in sql
SQL
1 vote276 views1 answer
How to drop function in sql
SQL
0 vote289 views1 answer
Sql server datetime
SQL
0 vote295 views1 answer
Group by join columns per table
SQL
3 votes280 views3 answers
Create table in microsoft sql server
SQL
8 votes283 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote325 views1 answer
New rails app with mysql
SQL