Performing where clause

Question

I have this client table:

+----------+----------+---------+ | cliecode | cliename | deleted | +----------+----------+---------+ | 00001 | ABC | | | 00002 | DEF | | | 00003 | GHI | yes | | 00004 | JKL | | +----------+----------+---------+

And I'm performing a search query like this:

SELECT * FROM client WHERE deleted ='' AND cliecode LIKE '%$_POST[key]%' OR cliename LIKE '%$_POST[key]%'

I want to fetch the deleted = '' first before the like condition. How can I do this? Thanks.

John Woo · Accepted Answer · 2013-03-14 08:31:30Z

4

then group your OR condition by putting them inside parenthesis,

select * from client where deleted ='' and (cliecode like '%$_POST[key]%' or cliename like '%$_POST[key]%')

edited Mar 14, 2013 at 8:31

answered Mar 14, 2013 at 8:25

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

xjshiya Over a year ago

Thanks for this. I'm not that good with MySQL yet so thanks kababayan. :)

Piyas De · Accepted Answer · 2013-03-14 08:28:30Z

have you set any defualt value in deleted field?

if not -

then your query should be -

select * from client where deleted is null and cliecode like '%$_POST[key]%' or cliename like '%$_POST[key]%'

Collectives™ on Stack Overflow

Performing where clause

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related