SELECT *
FROM table
WHERE type LIKE '%G%'
AND [a bunch of other stuff]
I have a column in this table called 'area' which contains the key values for another table. What I want to do is throw all values of 'area' that result from the above query (duplicates excluded) into an array. I feel like I should be able to do this without making another call to the database, but I can't figure it out.
You posted the question in Databases thus choosing the likely "solution" with that decision. The only other way is iterating over the result set pulling out the values manually.