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

4 votes238 views1 answer
Sql quote in string
SQL
0 vote237 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
2 votes251 views4 answers
Check timezone of mysql database
SQL
1 vote236 views1 answer
Oracle user last connection date
SQL
3 votes234 views2 answers
Brew start mysql
SQL
0 vote257 views2 answers
Wordpress change url after migration mysql query
SQL
5 votes222 views3 answers
Truncate function in sql oracle
SQL
0 vote239 views2 answers
Mysql add days to date
SQL
0 vote246 views1 answer
Postegresql update to null
SQL
0 vote245 views1 answer
How to print sql query
SQL