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 vote260 views2 answers
Postgresql user permissions to database
SQL
1 vote271 views1 answer
SQL query to get all table records count from a database
SQL
2 votes247 views1 answer
Sqlite indexes
SQL
1 vote242 views1 answer
Varchar plsql
SQL
1 vote277 views2 answers
Postgres select from last 3 months
SQL
1 vote247 views1 answer
How to select random rows from table
SQL
1 vote257 views1 answer
Oracle sql average
SQL
1 vote259 views1 answer
How to between in sql
SQL
0 vote278 views1 answer
Copying query result to excel
SQL
0 vote263 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL