I was trying to do something like this in Laravel:
DB::table('TABLE1')->join('TABLE2', 'COLUMN1', 'IN', '(1,2,3)')
but when I looked into Builder.php file, these are the only operators that are supported for ON clause:
public $operators = [
'=', '<', '>', '<=', '>=', '<>', '!=',
'like', 'like binary', 'not like', 'between', 'ilike',
'&', '|', '^', '<<', '>>',
'rlike', 'regexp', 'not regexp',
'~', '~*', '!~', '!~*', 'similar to',
'not similar to', 'not ilike', '~~*', '!~~*',
];
Is there any reason that IN is not listed in $operators?
from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2vSZQQx
via IFTTT
Aucun commentaire:
Enregistrer un commentaire