samedi 19 août 2017

Why laravel Query builder doesn't support joins with IN condition operator?

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