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:




Code:


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

FROM MyList

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!





Art




No comments:

Post a Comment