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

[evgeniystuchalk]

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?

[tresesco · Accepted solution]

Wildmatch() is a qv qlik function that doesn't get recognized by SQL engine. Rather try with Like, like:

...`status_name`<>'' and `responsible_user_name` like '%Мен%';