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 vote114 views1 answer
Select top 3 sql
SQL
0 vote111 views1 answer
Sql database connectivity
SQL
0 vote110 views1 answer
Partitioning in oracle-base
SQL
0 vote114 views2 answers
Update information in a mysql column
SQL
1 vote120 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote113 views1 answer
How to check even or odd in sql
SQL
0 vote120 views1 answer
Postgres drop type
SQL
0 vote116 views1 answer
Create table sql generator
SQL
0 vote128 views1 answer
How to locate pg_hba.conf file
SQL
0 vote113 views1 answer
Postgre admin slow
SQL