Solved

SELECT ... FROM ...WHERE .. (. OR .).. AND ...

Posted on 2006-10-28
1
312 Views
Last Modified: 2006-11-18
SELECT .. FROM `jobs` WHERE `jobs`.`description` LIKE '%finance%' OR `jobs`.`title` LIKE '%finance%' AND `jobs`.`rId` = 5 AND `jobs`.`status` = 1 AND `recruiters`.`status` = 1

This query gives too many results.
With OR I mean only the jobs.description OR jobs.title.

How can i fix this? Thanks in advance.



0
Comment
Question by:thijs321
1 Comment
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 50 total points
Comment Utility
SELECT .. FROM `jobs` WHERE (`jobs`.`description` LIKE '%finance%' OR `jobs`.`title` LIKE '%finance%' ) AND `jobs`.`rId` = 5 AND `jobs`.`status` = 1 AND `recruiters`.`status` = 1
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now