Laravel 5 Snippets

laravel5-snippets.md

Run sql dumps or exports

DB::unprepared(file_get_contents('/path/to/dump.sql'));

Query builder where clause operators

Defined in Illuminate/Database/Query/Builder.php

    protected $operators = [
        '=', '<', '>', '<=', '>=', '<>', '!=',
        'like', 'like binary', 'not like', 'between', 'ilike',
        '&', '|', '^', '<<', '>>',
        'rlike', 'regexp', 'not regexp',
        '~', '~*', '!~', '!~*', 'similar to',
                'not similar to',
    ];