在laravel中使用DB原始查询

Question

请协助将此SQL查询转换为laravel格式的

"update user_names  set assignedTo = '09874',Assigned=1 where timePackage='1 hr' and Assigned=0  order by id limit 1"

Answer 1

试试这个：

use IlluminateSupportFacadesDB;
DB::table('user_names')
->where('timePackage', '1 hr')
->where('Assigned', 0)
->orderBy('id')
->limit(1)
->update([
'assignedTo' => '09874',
'Assigned' => 1,
]);

请参阅Laravel文档了解更多信息。