php - Laravel Eloquent Query 首先有值而不是列名

Question

我正在尝试在 laravel eloquent 中运行以下查询，但我无法这样做。

SELECT * FROM vehicle_unavailabilities WHERE ("2021/06/05" NOT BETWEEN from_date and to_date) AND ("2021/06/07" NOT BETWEEN from_date and to_date)

如果我尝试

->whereNotBetween("2021/06/05",['from_date',['to_date'])

它给了我找不到列“2021/06/05”的错误。我怎样才能做到这一点？

标签： phpmysqllaraveleloquent

Answer 1

这应该是您的列名。

SELECT * FROM vehicle_unavailabilities WHERE ("COLUMN_NAME" NOT BETWEEN from_date and to_date) AND ("COLUMN_NAME" NOT BETWEEN from_date and to_date)

->whereNotBetween("COLUMN_NAME",['from_date', 'to_date'])