Solved

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

Posted on 2006-10-28
1
319 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 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 50 total points
ID: 17825254
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
Creating and Managing Databases with phpMyAdmin in cPanel.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

733 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