MYSQL Querying using OR and AND problem

Question

0.00/5 (No votes)

See more:

Helo, im just having a problem in mysql query, i am making a search query for my
customer to retrieve customer information, but im having trouble in using the OR and AND in my query, when i put an OR e.g(OR email LIKE '%search_customer%') my query works but the query retrieve all the information and disregard my AND statement e.g
(user_status = 'active') but when i remove the OR my query works pretty well,
but i need the OR statement to search more than 2 fields in my table and select all the user_status = "active" as well, is there something wrong with my query? Please help me cause i really need this query to be fixed cause i will be needing this kind of data retrieving in some of my module, Thank you very much

SQL

SELECT *
FROM tblusers
WHERE
business_name LIKE '%search_customer%' OR emal LIKE '%search_customer%'
AND user_status = 'active';
ORDER by business_name ASC

Posted 15-May-11 21:29pm

itwasbydesign

Updated 20-Jul-11 20:19pm

walterhevedeich

v2

Add a Solution

3 solutions

Solution 2

Well, I tried your SQL and, other than the semi-colon in the wrong place, it works fine (I take it that emal. is meant to be email and is just a typo in your question and not in the actual SQL). I would advise you to include the field names in your query rather than using the asterisk to select all fields, but that is just me.

Posted 15-May-11 21:51pm

Wayne Gaylard

Solution 3

Thanks Kim Togo6 :) i have test the new code and its work, to think that i am just missing a
"( )" in the query, thank you again, you saved my day!

Posted 15-May-11 22:11pm

itwasbydesign

Comments

Kim Togo 16-May-11 4:20am

You are welcome. Please use "Add Comment" under Solution, or else no email is sent to me about your update :-)

[no name] 16-May-11 4:33am

carlo beatisula - 7 mins ago
okay, thanks again for the help, would you mind if i ask for you email add,
just want to have connections with other people in this industry, ^_^

Kim Togo 16-May-11 4:41am

Yes of course. Search me up in linkedin.com.

[no name] 17-May-11 1:13am

what is your email add in linkedin.com?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kim Togo · Accepted Answer · 2011-05-15T21:45:00

Solution 1

You have to rewrite the SQL statement to

SQL

SELECT *
FROM tblusers
WHERE
(business_name LIKE "%search_customer%" OR emal LIKE "%search_customer%")
AND user_status = "active"
ORDER by business_name ASC

Use are missing "(" and ")" between business_name and emal.

Your WHERE statement is like:

business_name OR emal OR user_status = "active"

Posted 15-May-11 21:45pm

Kim Togo

Updated 15-May-11 21:57pm

v3

Comments

Sandeep Mewara 16-May-11 4:39am

my 5!

Kim Togo 16-May-11 4:41am

Thanks :-)