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 vote254 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
19 votes174 views6 answers
Sql server drop table if exists
SQL
2 votes189 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote166 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote197 views1 answer
Sqlalchemy empty table
SQL
6 votes172 views5 answers
Sql add months to date
SQL
19 votes167 views6 answers
Laravel sql query
SQL
11 votes195 views2 answers
Set default column value sql
SQL
3 votes185 views1 answer
Oracle user quota on tablespace
SQL
1 vote173 views1 answer
Rermove categories woocommerce sql
SQL