如何把含有別名和函式的sql轉成eloquent orm ?
環境:Laravel 8.7、php8.1、mysql5.7.xx
遇到的問題:
如何把這段sql轉成eloquent orm ?我嘗試許久一直卡住在date(mytimestamp
) AS formatDate
SELECT *,date(`mytimestamp`) AS formatDate FROM `xxxTable` WHERE id<10 ORDER BY formatDate DESC;
推荐文章: