2019-04-01 09:58
浏览 77

Sql whereNOTIn在laravel中

I need your support to use whereNOTIn with laravel 5 to show all id in (times) table and they not in (booking)table and user_id


The problem is 

I can't use




it gives me the result for the first ->where() and ignore

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dsdsm2016 2019-04-01 17:08

    You are in right track but , first thing you need to know is wherenotin is used to compare your value with the array of values , so first you need is a array of value : here is simple example to help you to understand a bit clearly so you can go through the problem : by using query builder DB::table('tablename')->select('fieldname')->whereNotIn('field1', [100,200])->get(); or by using qlequent model

    SomeModel::select('fieldname')->whereNotIn('field1', arraytmp)->get();

    解决 无用
    打赏 举报

相关推荐 更多相似问题