how handle "NOT" operation in where clause

[HASSANDL]

Hello. I want using "OR NOT" in sql. example:

SELECT * FROM users
WHERE id > 2 OR NOT (
    name LIKE '%sd' AND name LIKE '%sassd'
)

how handle in where clause Medoo? thanks.

[catfan]

Why don't just use [!~] for NOT LIKE?

https://medoo.in/api/where (LIKE Condition section)

$database->select('users', '*', [
    'OR' => [
        'id[>]' => 2,
        'AND' => [
            'name[!~]' => ['AND' => ['%sd', '%sassd']]
        ]
    ]
]);

The output:

SELECT * FROM `users` WHERE (`id` > 2 OR ((`name` NOT LIKE '%sd' AND `name` NOT LIKE '%sassd')))

[HASSANDL]

how handle this (NOT OR)?

$database->select('users', '*', [
    'NOT OR' => [
        'id[>]' => 2,
        'AND' => [
            'name' => ['AND' => ['%sd', '%sassd']]
        ]
    ]
]);

[catfan]

There is no NOT OR.