Code Forums - View Single Post

steph php · 06-12-2006, 08:51 AM

Hi

i am writing an sql statement to search a table of users. in the users table are the fields location1 location2 and location3. when someone searches for 'london' i need it to check each field. which i have done, however, what i really really want is for all the people who have 'london' in location1 to come up 1st then location2 people and so on. (prioritised search results)

all this in one query would be ideal but any help with this would be much appreciated !!!

Cheers guys/gals.

06-12-2006, 08:51 AM	#1 (permalink)
steph php Registered User Join Date: Jun 2006 Posts: 2	SQL Help !!! Hi i am writing an sql statement to search a table of users. in the users table are the fields location1 location2 and location3. when someone searches for 'london' i need it to check each field. which i have done, however, what i really really want is for all the people who have 'london' in location1 to come up 1st then location2 people and so on. (prioritised search results) all this in one query would be ideal but any help with this would be much appreciated !!! Cheers guys/gals.