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 vote186 views1 answer
Opensuse stop MySQL
SQL
2 votes204 views1 answer
Oracle trace session
SQL
0 vote203 views1 answer
Db format in quotation
SQL
0 vote198 views1 answer
MySQL error code 2068
SQL
1 vote206 views1 answer
Pgsql sum switch case
SQL
3 votes210 views2 answers
How to modify rows in SQL Server
SQL
0 vote192 views6 answers
Unique key in sql
SQL
12 votes212 views4 answers
Mysql get date difference in hours
SQL
0 vote217 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote190 views1 answer
Mysql select all table that have field names
SQL