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

17 votes139 views5 answers
Order by sql
SQL
1 vote127 views1 answer
Mysql size int
SQL
0 vote153 views1 answer
Mysql equivalent decode oracle
SQL
1 vote122 views1 answer
Data type and their numeric form
SQL
1 vote138 views1 answer
Show table status command in mysql
SQL
8 votes119 views3 answers
Alter table auto_increment
SQL
0 vote122 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
40 votes198 views4 answers
PostgreSQL add column
SQL
18 votes150 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
1 vote122 views2 answers
Mysql spring boot application.properties
SQL