i used COQL for api requests

$query= "select id, Name_for_1C from Invoices where ((Name_for_1C not like GoITeens) and (Date_of_receipt_of_payment > '2022-08-15'))";
$query= "select id, Name_for_1C from Invoices where ((Name_for_1C not like 'GoITeens') and (Date_of_receipt_of_payment > '2022-08-15'))";

but in result i found many records with Name_for_1C values like
{
            "Name_for_1C": "GoITeens_UA_MINE_1y_16",
            "id": "1819773000298062570"
        }, {
            "Name_for_1C": "GoITeens_UA_MINE_1y_16",
            "id": "1819773000301039112"
        }, {
            "Name_for_1C": "GoITeens_UA_MINE_1y_19",
            "id": "1819773000305694162"
        }

so i have a question
when will COQL start working adequately?



    Text, Picklist

    =, !=, like(used for starts_with, ends_with, contains), not like(used for not_contains), in, not in, is null, is not null.


not like(used for not_contains)

https://www.zoho.com/crm/developer/docs/api/v2/Get-Records-through-COQL-Query.html

facepalmApiDocs?