PHP app\models Player::whereRawの例

コード例 #1

ファイル: PlayerController.php プロジェクト: murribu/trumedia

 function getBatters()
 {
     $players = Player::whereRaw('id in (select player_id from player_positions where position_id <> 1)')->whereRaw('name like ?', array('%' . Input::get('q') . '%'))->limit(50)->orderBy('name')->get();
     return array('items' => $players, 'total_count' => count($players));
 }