CODEWITHSUNDEEP
mysql
Ajeet Kumar
Ajeet Kumar

Reputation: 166

Mysql case with or condition with or operator

How we select record in given mysql query : kindly help me to select query with case when var1 like value1 or var2 like value2 then 'valid' else 'invalid' from xx as s

select
    case
        when SUBSTRING(Trim(Pan_No), 4, 1) ='C'
        and (z.tds_Vendor_Type_Lookup_Code not like '%COMP%' or Vendor_Name not like '%Pvt%' or Vendor_Name not like '%Ldt%' or Vendor_Name not like '%Limited%' or Vendor_Name not like '%Private%'  )
    then 'InValid Pan 4th Character for a Company' end as code
    from xyz as a

in this query always run else condition please guide me a valid way.

Upvotes: 0

Views: 1130

Answers (1)

Abhik Chakraborty
Abhik Chakraborty

Reputation: 44844

You are missing the end statement for the case, in addition you can also add else something as

select 
case
 when SUBSTRING(Trim(Pan_No), 4, 1) ='C' 
 and (
   z.tds_Vendor_Type_Lookup_Code not like '%COMP%' 
   or Vendor_Name not like '%Pvt%' 
   or Vendor_Name not like '%Ldt%' 
   or Vendor_Name not like '%Limited%' 
   or Vendor_Name not like '%Private%'  
 ) 
 then 'InValid Pan 4th Character for a Company' 
 else 'Valid' end as validity
 from xyz

Upvotes: 2

Related Questions