Combine "And" and "OR" Conditions in MySQL

[TheYoungOne]

hello,

I need to combine several "And" and "OR" conditions but can't seem to make it work.

Conditions should be as followed:
All 'PCK' on the 17th of December picked by either a DW, a RT or an OP

What I have now doesn't consider the date constraint, so I'm guessing I'm missing some brackets?

	from PRODUCT_HISTORY            
                where                PTH_Type like 'PCK' 
		and                   CONVERT (date, PTH_GenDate) like '2018-12-17'
                and		        REST_Id like 'DOUBLE WALKY%'
	        or		        REST_Id like  'REACH TRUCK%'
		or			REST_Id like 'ORDER PICKER%'

Thanks

 

[arnelgp]

try adding bracket like:

	from PRODUCT_HISTORY            
                where                PTH_Type like 'PCK' 
		and                   CONVERT (date, PTH_GenDate) like '2018-12-17'
                and		       (REST_Id like 'DOUBLE WALKY%'
	        or		        REST_Id like  'REACH TRUCK%'
		or			REST_Id like 'ORDER PICKER%')

 

[TheYoungOne]

Nice, I added those plus some from "Where" Till the end and now it works
I'm learning

 

[Minty]

Purley on a semantic point the use of the Like is redundant when there are no wildcards used so you should use =

 where PTH_Type [COLOR="Red"]= [/COLOR]'PCK' 
and                   CONVERT (date, PTH_GenDate) [COLOR="red"]= [/COLOR]'2018-12-17' ...