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 vote285 views2 answers
Dumping sql table
SQL
13 votes266 views5 answers
Sql default
SQL
0 vote264 views1 answer
Get null value in sql
SQL
0 vote267 views2 answers
SQL BULK INSERT
SQL
1 vote275 views1 answer
Tsql update datetime
SQL
0 vote270 views1 answer
Sql composite key
SQL
0 vote293 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
1 vote257 views1 answer
Mysql remove last empty newline
SQL
0 vote265 views1 answer
Vbscript clean up ADODB.Recordset
SQL
22 votes336 views4 answers
Mysql format date
SQL