In datatable editor IN where clause how to give multiple values?

aruncraftsion

eg:
i need to give three pincode in where condition
->where( function ( $q )use ($pincode) {
$q->where( 'pincode',600011,600021,600024,'=');

} )

colin

Hi @aruncraftsion ,

You should be able to or_where there, see page here.

So something like:

->where( function ( $q ) {
  $q
    ->where( 'pincode', 600011,'=')
    ->or_where( 'pincode', 600021,'=')
    ->or_where( 'pincode', 600024,'=');
} )

Cheers,

Colin

colin

Duplicate of this thread.