Breaking News: Grepper is joining You.com. Read the official announcement!

How to remove a specific 'where' clause from the Query Builder

Uptight Unicorn answered on July 2, 2022 Popularity 1/10 Helpfulness 1/10

answer How to remove a specific 'where' clause from the Query Builder

How to remove a specific 'where' clause from the Query Builder

Comment

/**
     * @param Builder $builder
     * @param $whereColumn
     * @return Builder
     */
    public static function removeWhere(Builder $builder, $whereColumn)
    {
        $bindings = $builder->getQuery()->bindings['where'];
        $wheres = $builder->getQuery()->wheres;

        $whereKey = false;
        foreach ($wheres as $key => $where) {
            if ($where['column'] == $whereColumn) {
                $whereKey = $key;
                break;
            }
        }

        if ($whereKey !== false) {
            unset($bindings[$whereKey]);
            unset($wheres[$whereKey]);
        }

        $builder->getQuery()->wheres = $wheres;
        $builder->getQuery()->bindings['where'] = $bindings;

        return $builder;
    }

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: clause query-builder whatever

Link to this answer
Share Copy Link