laravel SQL 直書き
・controller
// $osirase = DB::select(DB::raw('SELECT annai_title, 夏目 智徹 FROM informs WHERE 夏目智徹 <= CURDATE() AND end_date >= CURDATE() order by sentence_number desc'));
SELECT
annai_title,
start_date,
annai_test
FROM
informs
WHERE start_date <= CURDATE()
AND end_date >= CURDATE()
order by sentence_number desc
SQL;
// var_dump($go_index_oshirase);
return view('yoyaku.index', ['go_index_oshirase' => $go_index_oshirase]);