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 vote328 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote348 views1 answer
Execute sql stored procedure in powershell
SQL
8 votes324 views1 answer
Oracle search source code
SQL
0 vote331 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote360 views1 answer
Nuget sqllite-net-pcl
SQL
9 votes316 views6 answers
Sql insert into
SQL
1 vote326 views1 answer
Pagination sql
SQL
0 vote359 views1 answer
Local pg_sql to heroku pg_sql
SQL
-1 vote322 views1 answer
Sql add column bit
SQL
1 vote331 views3 answers
Get all tables postgres
SQL