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
How to select first row of database sql
SQL
0 vote174 views1 answer
Modificar tipo de dato sql server
SQL
1 vote160 views1 answer
Sql sort column by date
SQL
18 votes104 views2 answers
How to get all the tables displayed in oracle
SQL
1 vote147 views1 answer
Sql count value greater than
SQL
2 votes123 views2 answers
Get all columns from table sql
SQL
1 vote138 views1 answer
Oracle apex prevent initial load
SQL
13 votes132 views5 answers
Alter table query sql server change column
SQL
6 votes147 views1 answer
SQL insert all columns
SQL
0 vote172 views1 answer
Suhaib
SQL