Horje
sql where contains Code Example
like sql 
WHERE CustomerName LIKE 'a%'	
--Finds any values that start with "a"
WHERE CustomerName LIKE '%a'	
--Finds any values that end with "a"
WHERE CustomerName LIKE '%or%'	
--Finds any values that have "or" in any position
WHERE CustomerName LIKE '_r%'	
--Finds any values that have "r" in the second position
WHERE CustomerName LIKE 'a__%'	
--Finds any values that start with "a" and are at least 3 characters in length
WHERE ContactName LIKE 'a%o'	
--Finds any values that start with "a" and ends with "o"
sql not contains 
SELECT * FROM tbl WHERE tbl.col NOT LIKE '%text%';
sql where contains 
SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
   OR column1 LIKE '%word2%'
   OR column1 LIKE '%word3%'
Source: stackoverflow.com
sql where contains part of string 
-- To find an exact string
SELECT * FROM [table] WHERE [field] LIKE '%stringtosearchfor%'.
Source: stackoverflow.com
t_sql contains 
SELECT * FROM table WHERE Contains(Column, "test");
Source: stackoverflow.com




Related
install sqlite3 python Code Example install sqlite3 python Code Example
select count of distinct values sql Code Example select count of distinct values sql Code Example
mysql set root password Code Example mysql set root password Code Example
how to change the value of a table in sql Code Example how to change the value of a table in sql Code Example
postgresql add column with constraint Code Example postgresql add column with constraint Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 11



 

Horje