1 Reply Latest reply: Dec 3, 2015 7:03 AM by Tresesco B RSS

    Using "where" on load from DB: problem with 'wildmatch' function

    Evgeny Stuchalkin

      Hello! Here is my code in the end of load sript:


      FROM `amo_akz`.leads where `status_name`<>'Новый заказ' and `status_name`<>'Ожидает подтверждения (Call center)' and `status_name`<>'' and wildmatch(`responsible_user_name`,'*Мен*')='1';

       

      On compilation i'm getting error:

       

      SQL##f - SqlState: 37000, ErrorCode: 1305, ErrorMsg: [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.38-0+wheezy1]FUNCTION amo_akz.wildmatch does not exist


      Without "wildmatch" everething is ok. What to do to make it work?