CREATE TABLE table_1585609_2 (date_of_designation VARCHAR, name VARCHAR)

Name all the date of designations for kurume
SELECT date_of_designation FROM table_1585609_2 WHERE name = "Kurume"
SELECT "date_of_designation" FROM "table_1585609_2" WHERE "Kurume" = "name"