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

27 votes118 views5 answers
Mysql set password for user
SQL
4 votes110 views1 answer
Change nls_date_format
SQL
1 vote124 views1 answer
How to put value in variable mysql
SQL
0 vote119 views1 answer
Postgres week number
SQL
10 votes128 views4 answers
Else if mysql
SQL
18 votes122 views3 answers
Get the list of all tables in sql server
SQL
0 vote130 views3 answers
Join
SQL
0 vote111 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote107 views1 answer
Lost connection to mysql
SQL
4 votes145 views1 answer
Sql select limit range
SQL