Sql

Search

sql contains vs like

SELECT * FROM table WHERE Column LIKE '%test%';		-- can't use index
SELECT * FROM table WHERE CONTAINS(Column, 'test'); -- faster with full text index

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql cte example
Sql :: insufficient privileges while creating view in sql oracle
Sql :: npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! sqlite3@4.2.0 install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the sqlite3@4.2.0 install script.
Sql :: how to show current database in mysql
Sql :: Question 7: Write an SQL query to print details of the Workers who have joined in Feb’2014.
Sql :: SQL Copy From Two Tables to One
Sql :: initialize sql date
Sql :: creating tables in sql with python
Sql :: oracle all columns
Sql :: plsql find location of procedure
Sql :: check constraint in ms sql
Sql :: json_modify sql server
Sql :: sqlalchemy existing db file
Sql :: mysql delet from the child table when we delete the rows from the parent
Sql :: oracle sql get value from several rows and concatenate strings
Sql :: copy data from one database to another
Sql :: sql min
Sql :: Triggers Syntax
Sql :: mysql allow connection from any host
Sql :: postgresql create user roles
Sql :: postgres disable foreign keys
Sql :: how to use join with 3 tables in sql server
Sql :: mysql foreign key
Sql :: last mysql
Sql :: min and max salary and name in sql
Sql :: mysql with docker
Sql :: what is auto increment in sql
Sql :: new rails app with mysql
Sql :: join multiple tables in sql same table
Sql :: mysql client onnection error

Search

SQL

sql contains vs like

ADD CONTENT