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 vote205 views5 answers
Mode sql course
SQL
0 vote204 views1 answer
Java mysql swing example
SQL
0 vote206 views1 answer
Oracle merge insert if not exists
SQL
0 vote203 views1 answer
Postgresql default value boolean
SQL
3 votes176 views1 answer
Postgresql where current year
SQL
8 votes266 views2 answers
Python simple connect to mysql
SQL
4 votes177 views1 answer
Sql list users and roles
SQL
6 votes216 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote214 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote190 views1 answer
Oracle sql count occurrences of value in column
SQL