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

4 votes127 views1 answer
Mysql insert from local csv
SQL
1 vote159 views2 answers
End mysql command
SQL
0 vote128 views1 answer
Sql check for null and empty string
SQL
4 votes159 views1 answer
Is there any command to change postgres password
SQL
0 vote129 views1 answer
How to get data between a last week in mysql
SQL
0 vote144 views2 answers
Sql searching via key word
SQL
0 vote143 views1 answer
Date on SQL
SQL
0 vote141 views1 answer
Oracle synonym procedure dblink
SQL
1 vote156 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote132 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL