On 23/01/15 11:50, dealTek wrote:
Hi all, (newbie question)
- let's say, (for some other reasons I'll skip here) I needed to do two separate queries to the same mysql contacts table (rather than one more elegant combined one)
1 - find everybody from California
2 - find everybody from Texas
Then – I would like to combine both of these queries into some kind of an array that I could loop through and display after sorting by last name
Q: I am curious the best way to combine the 2 separate queries into 1 afterwards?
Hi dealTek,
If you are using MySQL you could look at the UNION clause. It allows you
to do two very different queries and combine them into one result set /
array.
1st hit I could find.
http://www.w3schools.com/sql/sql_union.asp
eg:
SELECT City, State FROM contacts
WHERE State='California' AND cat_lover = 'Yes'
UNION ALL
SELECT City, State FROM contacts
WHERE State='Texas' AND has_hats = 'No'
ORDER BY City;
Would that achieve the same result in one query?
Cheers
P