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

3 votes340 views3 answers
Stop mysql service ubuntu
SQL
6 votes338 views1 answer
Postgresql get year
SQL
0 vote334 views1 answer
Including parameters in OPENQUERY
SQL
0 vote368 views1 answer
Hibernate show sql xml property
SQL
0 vote353 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote351 views1 answer
Codigo crear tablas sql server
SQL
3 votes359 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
1 vote355 views1 answer
Import database from a file using mysql commandline
SQL
0 vote453 views1 answer
Run docker container with database as rds metabase
SQL
0 vote345 views1 answer
Mysql select where field is a value
SQL