Not saying it is best but you could do this. Change your map to be 'map {"state=?"} @$citydata'. Then pull the states out of @$citydata and into an array and pass this array to the exec_select().