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

1 vote238 views1 answer
Hackerrank sql test solutions
SQL
6 votes199 views3 answers
Sql select last id
SQL
1 vote187 views1 answer
Mysql login console
SQL
1 vote191 views1 answer
Get table which have specific columns in mysql
SQL
0 vote246 views4 answers
Best data type to represent money in mysql
SQL
13 votes188 views5 answers
Oracle list tables
SQL
0 vote171 views1 answer
Sql cross apply vs join
SQL
0 vote198 views1 answer
Insert ip address in mysql
SQL
0 vote244 views2 answers
Sql unique
SQL
5 votes162 views1 answer
Alter table default value mysql
SQL