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"
