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 vote154 views1 answer
Mariadb alter user host
SQL
49 votes225 views6 answers
Alter table add column
SQL
5 votes166 views1 answer
Sql table columns
SQL
0 vote163 views1 answer
Is not sql
SQL
0 vote143 views1 answer
Oracle sql count occurrences of value in column
SQL
15 votes160 views2 answers
Select where duplicate mysql
SQL
0 vote179 views1 answer
How to combine rows in sql server procedure
SQL
24 votes163 views4 answers
Mssql get all table names
SQL
1 vote170 views3 answers
How to pass password to mysql command line
SQL
0 vote142 views1 answer
Mysql sql select one day before
SQL