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 which is a little perplexing to me. Just a little background as to how it works - The person can choose a county and a basic job description, and I make the query string dependant on what they choose. For example, if they choose one specific county or select "all counties," it sets the query appropriately. The problem that I have is - if there are 7 counties, I've got the string saying: select * from jobs where (county='county1' or description like '%county1%' or title like '%county1%') or (county='county2' or description like '%county2%' or title like '%county2%') .... etc, and if they choose a specific keyword it then throws that into the query. The computer is a dual P3 1GZ w/1.5GB's of RAM - RedHat 7.2 - PERL DBI - it takes over 3 seconds to complete queries like that, and I know that I can get it faster. Any suggestions would be appreciated sincerely. Thanks, --Bill --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
