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 vote199 views2 answers
SQL FROM
SQL
1 vote180 views1 answer
How to install mysql 8.0 windows service
SQL
3 votes179 views3 answers
Sql last week
SQL
0 vote196 views1 answer
Geopoint from json mysql function
SQL
0 vote174 views1 answer
Update if else mysql
SQL
0 vote150 views1 answer
Java spring boot connect to sql server
SQL
15 votes185 views2 answers
Open postgress in terminal mac
SQL
0 vote185 views1 answer
Allow external access to mysql
SQL
1 vote237 views1 answer
Sql comment header
SQL
5 votes205 views4 answers
Start postgres server
SQL