PHP App\Nrna\Models Post::whereRaw Examples

Example #1

File: PostRepository.php Project: Shuvayatra/migration-web

 /**
  * @param $query
  *
  * @return mixed
  */
 public function search($query, $paginate = false)
 {
     $query = $this->post->whereRaw("to_tsvector(metadata->>'description') @@ plainto_tsquery('" . $query . "')")->OrWhereRaw("to_tsvector(metadata->>'title') @@ plainto_tsquery('" . $query . "')");
     if ($paginate) {
         return $query->paginate();
     }
     return $query->get();
 }