Keep SQL query order from OR statement

[Zeradin]

I have a query that looks like this:

 

SELECT * FROM table WHERE (zip = "foo" OR zip = 94105 OR zip = 94106 OR zip = 94150 OR zip = 94152 OR zip = 94163 OR zip = 94177 OR zip = 94104 OR zip = 94162 OR zip = 94126 OR zip = 94151 OR zip = 94138 OR zip = 94156 OR zip = 94145 OR zip = 94108 OR zip = 94120 OR zip = 94137 OR zip = 94139 OR zip = 94111 OR zip = 94161 ) AND `visible` = 1 AND state = "CA"

 

and I want it to output the results that way, but it outputs some of the 94105 then some 94104 then more 94105 then 94108

 

Is there a way to do this?

[Mchl]

SELECT * FROM table WHERE zip IN ("foo",94105,94106,94150...) AND `visible` = 1 AND state = "CA" ORDER BY zip ASC

 

or perhaps

 

(SELECT * FROM table WHERE zip = "foo" AND `visible` = 1 AND state = "CA")
UNION
(SELECT * FROM table WHERE zip IN (94105,94106,94150...) AND `visible` = 1 AND state = "CA" ORDER BY zip ASC)

[Zeradin]

the zips aren't in numerical order, they are in order of closeness to a different zip code

[Mchl]

Oh, ok

 

http://imthi.com/blog/programming/mysql-order-by-field-custom-field-sorting.php

[Zeradin]

Maybe I'm not explaining this properly. There's nothing in the table that will show the order. have an array of zip codes in what is essentially a random order (from the perspective of the table) and I add them to the SQL query in that order, hoping that it will select them in that order, but it doesn't. It's like:

 

I have this zipcode: 94105

i get a list of zip codes within 5 miles of it

I say SELECT * FROM table WHERE zip_code is "whatever" [OR loop through array to add zips in order]

 

[Mchl]

Well? If you can put them in order in WHERE clause, you can also put them in order into ORDER BY FIELD()

 

SELECT * FROM table WHERE zip IN ("foo",94105,94106,94150...) AND `visible` = 1 AND state = "CA" ORDER BY FIELD(zip,"foo",94105,94106,94150...) ASC

[Zeradin]

Oh I see what you did there. Thanks for your patience!