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 vote238 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote208 views1 answer
WHERE not regex in SQL
SQL
0 vote217 views1 answer
Postgres - Login and connect as default user
SQL
0 vote194 views4 answers
Mysql on kubernetes
SQL
0 vote187 views1 answer
Sql find leading space
SQL
0 vote194 views2 answers
Dbms transaction tutorialspoint
SQL
1 vote196 views1 answer
How to run parallel queries in sql server with entity framework
SQL
28 votes202 views6 answers
Mysql change user password
SQL
1 vote205 views3 answers
How to truncate foreign key constraint table
SQL
0 vote172 views1 answer
Sql examples from your work
SQL