Select using Like about medoo HOT 9 CLOSED

if (isset($where['xLIKE']))
    {
        $like_query = $where['xLIKE'];
        if (is_array($like_query))
        {
            $is_OR = isset($like_query['OR']);

            if ($is_OR || isset($like_query['AND']))
            {
                $connector = $is_OR ? 'OR' : 'AND';
                $like_query = $is_OR ? $like_query['OR'] : $like_query['AND'];
            }
            else
            {
                $connector = 'AND';
            }

            $clause_wrap = array();
            foreach ($like_query as $column => $keyword)
            {
                if (is_array($keyword))
                {
                    foreach ($keyword as $key)
                    {
                        $clause_wrap[] = $this->column_quote($column) . ' LIKE ' . $this->quote('' . $key . '%');
                    }
                }
                else
                {
                    $clause_wrap[] = $this->column_quote($column) . ' LIKE ' . $this->quote('' . $keyword . '%');
                }
            }
            $where_clause .= ($where_clause != '' ? ' AND ' : ' WHERE ') . '(' . implode($clause_wrap, ' ' . $connector . ' ') . ')';
        }
    }

$single_condition = array_diff_key($where, array_flip(
    explode(' ', 'AND OR GROUP ORDER HAVING LIMIT LIKE MATCH xLIKE')
));

$data = $conn->select("item_data", [

    "[>]item_general"   =>  ["id" => "id"]

],[

    "item_general.country",
    "item_general.lastupdate",
    "item_data.title",
    "item_data.category",
    "item_data.price",
    "item_data.currency",
    "item_data.url_details"

],[

    "xLIKE" => [

        "item_data.title" => "Title"    

    ],

    "ORDER" => "item_data.price"

]);

$database->select("account", [
    "user_id",
    "user_name",
],[

    "LIKE" => [
        // Match %title%
        "content" => "something"

        // Match %title
        "%content" => "something"

        // Match title%
        "content%" => "something"
    ]

]);

$database->select("account", [
    "user_id",
    "user_name",
],[

    "LIKE" => [
        // Match %title%
        "content" => "something"

        // Match %title
        "%content" => "something"

        // Match title%
        "content%" => "something"
    ]

]);