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

1 vote207 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote173 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote163 views1 answer
Show table structure mysql console
SQL
-1 vote195 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote180 views1 answer
Sql add calculated column
SQL
0 vote221 views1 answer
How to get table id sequence postgres
SQL
0 vote176 views2 answers
How to find sql server agent jobs related to a database
SQL
2 votes179 views1 answer
Mysql application.properties spring boot
SQL
104 votes289 views2 answers
Like in mysql
SQL
0 vote187 views1 answer
Sql period overlap
SQL