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 vote334 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote335 views1 answer
Delete from table where length sql
SQL
0 vote307 views1 answer
Change filed order in mysql
SQL
0 vote309 views1 answer
Add mysql database to power bi web
SQL
1 vote294 views3 answers
How to truncate foreign key constraint table
SQL
0 vote290 views1 answer
T sql check active deadlock
SQL
2 votes311 views1 answer
Datetrunc
SQL
2 votes336 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote316 views1 answer
Oracle sql all days except weekends
SQL
5 votes280 views1 answer
Update sql user password
SQL