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 vote257 views1 answer
Mysql delete entire row on condition
SQL
0 vote147 views1 answer
Sql developer connect to sql server
SQL
22 votes143 views3 answers
Join three tables sql
SQL
28 votes145 views6 answers
Sql update
SQL
10 votes140 views1 answer
Create table oracle
SQL
0 vote134 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote137 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
3 votes177 views2 answers
Enter mysql command line
SQL
1 vote151 views1 answer
Sql try catch
SQL
0 vote137 views1 answer
Declare date variable sql
SQL