Illuminate\Database\Query\Builder::selectRaw PHP Method

selectRaw() public method

Add a new "raw" select expression to the query.
public selectRaw ( string $expression, array $bindings = [] ) : Builder | static
$expression string
$bindings array
return Builder | static
    public function selectRaw($expression, array $bindings = [])
    {
        $this->addSelect(new Expression($expression));
        if ($bindings) {
            $this->addBinding($bindings, 'select');
        }
        return $this;
    }

Usage Example

Example #1
0
 private function getQuery()
 {
     $concat = [];
     foreach ($this->by as $id) {
         $concat[] = "ifnull(`{$id}`,'')";
     }
     $key = "concat(" . implode(",'-',", $concat) . ") as `__key`";
     $columns = implode(",", array_merge([$key], $this->sync));
     return $this->builder->selectRaw($columns);
 }
All Usage Examples Of Illuminate\Database\Query\Builder::selectRaw