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

15 votes206 views4 answers
Sql update from select
SQL
0 vote172 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote179 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote185 views2 answers
Greater than sql server
SQL
1 vote141 views2 answers
Delete auto increment mysql
SQL
0 vote174 views1 answer
Sql if else in select
SQL
1 vote189 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote167 views1 answer
Do postgresql
SQL
0 vote133 views1 answer
Java spring jdbc connect to postgresql
SQL
3 votes175 views3 answers
Mysql select table names
SQL