带有或运算符的Mysql案例或条件

Question

我们如何在给定的mysql查询中选择记录：请帮助我选择查询用大小写当var1像值1或var2像值2然后'有效'其他'无效'从xx作为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

在这个查询总是运行其他条件请指导我一个有效的方法。

Answer 1

您缺少案例的end语句，此外，您还可以添加else如下内容

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