Laravel Eloquent检查日期是否与数据库中的日期不相等

Question

How to make an Eloquent query that will check if date is not same as data as my database?

Currently what I tried is (my data in database is in timestamp, in Y-m-d H:i:s format, while my input only must in Y-m-d format)

$date = date('Y-m-d', strtotime($date));

//query something like this
Table::where('date', 'NOT LIKE', $date)->get();

Weirdly enough this does not work, any workaround?

Answer 1

Just add a "%" sign to the end of your date for the LIKE:

$date = date('Y-m-d', strtotime($date)) . '%';