# Create a table to associate a key with 0 or more values
CREATE TABLE associative_array (KEY_COLUMN VARCHAR(10), VALUE_COLUMN VARCHAR(100));
# Insert a Key Value pair
INSERT INTO associative_array (KEY_COLUMN, VALUE_COLUMN) VALUES ('KEY', 'VALUE');
# Retrieve a key value pair
SELECT aa.value_column FROM associative_array aa where aa.key_column = 'KEY';