Discussions

Expand all | Collapse all

not ILIKE function in mapd

  • 1.  not ILIKE function in mapd

    Posted 10-31-2019 00:32
    Edited by Nagulan Santhi 11-14-2019 20:45
    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 10-31-2019 02:23
    Hi @Omnisci user,

    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%');