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 vote308 views1 answer
Inserted row count tsql
SQL
6 votes293 views1 answer
Postgresql get year
SQL
5 votes307 views2 answers
Postgre insert select
SQL
0 vote297 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote343 views1 answer
Get role postgres
SQL
0 vote287 views2 answers
Select limit ms sql
SQL
0 vote298 views1 answer
Login failed for login due to trigger execution
SQL
0 vote303 views1 answer
Min and max salary and name in sql
SQL
0 vote314 views1 answer
Sql server select record with max id
SQL
0 vote317 views1 answer
Query to remove duplicate rows from a table
SQL