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

2 votes138 views1 answer
Find column in all stored procedures sql server
SQL
0 vote120 views1 answer
SQL: calculate hours from two dates
SQL
1 vote139 views1 answer
Sql server set variable if exists
SQL
0 vote110 views1 answer
Postgresql if else endif
SQL
0 vote105 views1 answer
Mysql jdbc timezone
SQL
10 votes174 views2 answers
Doublon sql
SQL
0 vote118 views1 answer
Psql generate id in existing database
SQL
1 vote152 views1 answer
Sql comment header
SQL
39 votes174 views4 answers
Select duplicates in sql
SQL
1 vote123 views1 answer
Postgres format date in select
SQL