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 vote133 views1 answer
Search for tables with name postgresql
SQL
1 vote136 views1 answer
Sql count value greater than
SQL
0 vote128 views1 answer
Groupby sort sql hive
SQL
0 vote128 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
3 votes137 views1 answer
Unsigned int in mysql
SQL
26 votes137 views2 answers
Mysql workbench download
SQL
0 vote124 views1 answer
Postgresql like
SQL
0 vote147 views1 answer
Postgresql show owner of database
SQL
4 votes131 views1 answer
Postgres delete last row
SQL
0 vote137 views1 answer
Reona
SQL