Discussions

Expand all | Collapse all

not ILIKE function in mapd

  • 1.  not ILIKE function in mapd

    Posted 21 days ago
    Edited by Nagulan Santhi 6 days ago
    Hi
     
    is there any option as not like function same as like function in mapd 

    
     in this query is there any way to use NOT ILIKE function in mapd
    #Core
    #Immerse


  • 2.  RE: not ILIKE function in mapd

    Posted 21 days ago
    Hi @Nagulan Santhi,

    as stated in the docs the only patter match function you can use with not is the like

    As a workaround, you can try this

    SELECT distinct(\"m5db9621b_sales_order_form\".m_shiptoname) AS \"label_sales_order_form.shiptoname\" 
    FROM m5db9621b_sales_order_form 
    WHERE not (1=1 and \"m5db9621b_sales_order_form\".m_shiptoname ILIKE '%usa%');