Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

like query

#SELECT * FROM table_name WHERE columnName LIKE pattern;
SELECT * FROM wilayah_2020 WHERE kode LIKE "82%" 

kode			nama 	
---------------------------------
82.72.08 		Tidore Timur
82.72.08.1001 	Mafututu
82.72.08.1002 	Tosa
82.72.08.1003 	Dowora
82.72.08.1004 	Kalaodi
82.72.08.1005 	Cobodoe
82.72.08.1006 	Doyado
82.72.08.1007 	Jiko Cobo

# 'a%'	Finds any values that start with "a"
# '%a'	Finds any values that end with "a"
# '%or%'	Finds any values that have "or" in any position
# '_r%'	Finds any values that have "r" in the second position
# 'a_%'	Finds any values that start with "a" and are at least 2 characters in length
# 'a__%'	Finds any values that start with "a" and are at least 3 characters in length
# 'a%o'	Finds any values that start with "a" and ends with "o"
 
PREVIOUS NEXT
Tagged: #query
ADD COMMENT
Topic
Name
8+7 =