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 vote182 views1 answer
How to reset the database value in SQL server
SQL
0 vote245 views2 answers
Cascade syntax in sql
SQL
2 votes218 views6 answers
In operator in sql
SQL
-1 vote227 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote195 views1 answer
Create dump file mysql workbench
SQL
0 vote292 views1 answer
Placements hackerrank solution
SQL
0 vote186 views1 answer
Import sql in postgresql
SQL
0 vote177 views1 answer
Restore backupfile discourse
SQL
13 votes191 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote195 views1 answer
Empty table sqlite
SQL