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 vote274 views1 answer
Increasing font and zooming in mysql workbench
SQL
15 votes274 views3 answers
Find duplicate keys in mysql
SQL
0 vote292 views1 answer
Change date in pivot table to month in sql server
SQL
1 vote298 views1 answer
Postgresql if 0 then 1
SQL
0 vote295 views1 answer
Update sql sintax
SQL
2 votes233 views1 answer
Mysql admin u root p password change password
SQL
0 vote265 views1 answer
Incorrect string value: mysql
SQL
0 vote290 views2 answers
Unique key
SQL
0 vote274 views2 answers
Get top 1 row of each group
SQL
1 vote284 views1 answer
OstgreSQL version
SQL