Unix iTOps Tube

Monday, May 7, 2012

mysql query multiple records for one field

Hello Group,

What I have is a database with about a dozen fields and one being "City".

What I would like to do is to have a custom query on a single field for multiple items (cities) but I don't know how to do this. I know this is probably kids play for most of you but I am lost. What I have got to work is a single city from the list but I do not know how to "ADD", "OR" or what I need to do next to add a second city so the results displayed contain both cities.

What I have so far is this:


SELECT MyList.`Filed Date` AS `Filed Date`,

  MyList.City AS City,

  MyList.State AS State,

  MyList.`Zip Code` AS `Zip Code`,

  MyList.Street AS Street,

  MyList.Owner AS Owner


WHERE MyList.City = _latin1'Buffalo'

Not sure what to add to the WHERE to add more city names other than "Buffalo" to the "City" field.:wall:

Thanks in advance for any replies!


No comments:

Post a Comment