Re: Basic Dual Query Combine into one question

Piers am Freitag, 23. Januar 2015 - 03:26: > 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 > Hi, Even more simple, try: SELECT City, State FROM contacts WHERE (State="California" OR State="Texas") ORDER BY lastname (you have something like a "lastname"-field in your contacts, I suppose) Cheers, Niklaus