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

7 votes257 views1 answer
Mysql unsafe update
SQL
1 vote280 views1 answer
How to between in sql
SQL
6 votes303 views3 answers
How to delete table sqlite
SQL
3 votes295 views1 answer
Postgresql if null then 0
SQL
3 votes279 views2 answers
Brew restart mysql
SQL
-1 vote264 views3 answers
Mysql get age from date
SQL
0 vote287 views1 answer
Check connections to database postgres
SQL
0 vote281 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote263 views1 answer
Is numeric in sql
SQL
3 votes276 views1 answer
Select table column in sql
SQL