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 vote217 views1 answer
Psql not found windows
SQL
0 vote231 views1 answer
View to table
SQL
0 vote226 views1 answer
Equi joins in oracle
SQL
0 vote231 views1 answer
Sql #region
SQL
0 vote213 views1 answer
Oracle string substitution
SQL
3 votes207 views4 answers
Show columns from table
SQL
9 votes244 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote214 views1 answer
Downgrading sql localdb visual studio
SQL
2 votes210 views3 answers
How to get second highest salary in each department in sql
SQL
4 votes227 views1 answer
SQL find text in SP
SQL