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 vote240 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote273 views1 answer
Sqlite schema structure of a relational database
SQL
1 vote202 views1 answer
Display total number of tables in mysql
SQL
0 vote213 views1 answer
Mysql root localhost run
SQL
3 votes246 views1 answer
Oracle nextval insert
SQL
0 vote194 views1 answer
Oracle right characters
SQL
2 votes219 views1 answer
Removing view
SQL
0 vote179 views1 answer
Dump only schema
SQL
1 vote258 views1 answer
How to put value in variable mysql
SQL
2 votes217 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL