Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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
Comment
PREVIOUS NEXT
Code Example
Sql :: check duplicate values plsql 
Sql :: select new table sql 
Sql :: create database sql 
Sql :: sql blank vs null 
Sql :: create index mysql cli 
Sql :: sql pagination oracle 
Sql :: SQL Auto Increment Primary Key - PostgreSQL 
Sql :: vowels in sql 
Sql :: where id is in list sql 
Sql :: how to run mysql on terminal mac 
Sql :: kill a pid redshift 
Sql :: select milliseconds mysql 
Sql :: mysql record group by created date count 
Sql :: how to identify locked tables in sql server 
Sql :: 1396(hy00) mysql error 
Sql :: sql left characters 
Sql :: oracle apex charging debug 
Sql :: ascending order and where in sql 
Sql :: print integer and string in SQL 
Sql :: sqlite get last 
Sql :: mysql export database command line 
Sql :: mysql backup database 
Sql :: sqlite unique 
Sql :: with postgres 
Sql :: remove foreign key constraints in postgres 
Sql :: postgres like case insensitive 
Sql :: alter table mysql 
Sql :: SQL: get date difference in minutes 
Sql :: SQL Database backup history 
Sql :: pgsql is not permitted to log in 
ADD CONTENT
Topic
Content
Source link
Name
5+7 =