WebLinuxStudy

导航

 


SELECT * FROM user WHERE (`id` = 1 OR `name` LIKE '%1%');

DB::table('user')

  ->select(['*'])
  ->where(function ($query) use ($idOrName) {
    $query->where('id', $idOrName)
          ->orWhere('name', 'like', "%{$idOrName}%");
  })
  ->get();

 

posted on 2022-07-05 17:33  WebLinuxStudy  阅读(83)  评论(0)    收藏  举报