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 vote120 views1 answer
How to get previous year from sysdate in oracle
SQL
3 votes58 views4 answers
Show columns from table
SQL
0 vote106 views1 answer
Mysql select inside sum
SQL
0 vote105 views1 answer
How to get inserted id in sql server
SQL
0 vote102 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote106 views1 answer
Postgres regex word boundary
SQL
1 vote107 views1 answer
Mysql sort by date column
SQL
25 votes144 views5 answers
Mysql replace text
SQL
0 vote117 views1 answer
How to move a column to different spot mysql
SQL
0 vote92 views2 answers
How to start postgresql laravel
SQL