[SOLVED] Mysql SELECT multiple

[Guest]

SELECT DISTINCT * FROM zipcode WHERE STATE='FL' AND CITY='ORLANDO' OR STATE='FL' AND CITRY='WINTER PARK' AND ZIP_CLASS='STANDARD'

 

Im trying to select zipcodes from th database where city is orlando or winter park and state = florida and zipclass = standard

I dont know how to do this exactly can someone help me?

[richardw]

Try using DISTINCT on one field in your table first. Also, is ZIP_CLASS defined?

 

<?php

SELECT DISTINCT FROM fieldnamehere WHERE (CITY = 'ORLANDO' OR CITY = 'WINTER PARK' ) AND ZIP_CLASS='STANDARD';

?>

 

OR I think you may mean this... a guess anyway. Also be aware of the case, ie ORLANDO will not match Orlando.

 

<?php

SELECT DISTINCT FROM ZIP_CLASS WHERE (CITY = 'ORLANDO' OR CITY = 'WINTER PARK' ) ORDER BY ZIP_CLASS asc;

?>

 

best

 

[fenway]

MySQL column values are case-insenstive for searching, unless the collation says otherwise (not the default).

 

Also, DISTINCT * makes no sense whatsoever.

[Guest]

Thank you i got it.