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 vote343 views3 answers
How to truncate foreign key constraint table
SQL
0 vote366 views1 answer
Mssql unique key accept nulls
SQL
5 votes366 views2 answers
Sql server port number
SQL
0 vote335 views1 answer
Sum value by month sql
SQL
4 votes341 views3 answers
Mysql modify foreign key
SQL
-3 votes321 views1 answer
Remove spaces sql 2008
SQL
7 votes372 views3 answers
Sql set
SQL
0 vote351 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
1 vote348 views2 answers
Sql now - 1 day
SQL
0 vote343 views1 answer
Services.AddDbContext DataSource Sqlite
SQL