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 vote381 views1 answer
Oracle activate program
SQL
0 vote379 views1 answer
View to table sql
SQL
0 vote382 views1 answer
What is top n result in sql
SQL
0 vote389 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote341 views2 answers
Sql query unique
SQL
3 votes342 views1 answer
Oracle detect invalid password
SQL
2 votes380 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
9 votes399 views3 answers
Where clause sql
SQL
0 vote392 views1 answer
Postgres list users and roles
SQL
0 vote352 views1 answer
Datagrip exec
SQL