#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"