Re: Newbie Question - Long Queries

2002-01-04 Thread Anvar Hussain K.M.
Hi Bill, Try putting first all the county equality tests together and then the other tests in the where clause. select * from jobs where (county = 'county1',' or county = 'county2'... or description like '%county1%' or or description like '%county2' ... or title like '%county1%' or title lik

Newbie Question - Long Queries

2002-01-04 Thread Bill Pierson
Greetings all, I'm new to the list, and I'm somewhat new to MySQL. I have a somewhat simple question that I hope someone can help me with. I'm designing a database for a job search. There are a little over 10,000 entries in the db. I need to query the database to accomplish a few results, one of