Reverse query with similar - laravel eloquent or raw MySQL query

Question

Reverse query with similar - laravel eloquent or raw MySQL query

I have a table with user submitted links. Some links do not contain

`http://`

I want to list these records using the following query:

        $object = Related::whereHas( function($q)
                {
                $q->where('URL', 'like', 'http%');

                    })->get();

How do I cancel a request to receive them?

thank

+3

mysql reverse eloquent laravel laravel-5

Peter May 03 '15 at 4:56

source to share

1 answer

Marcin Nabiałek · Accepted Answer · 2015-05-03T11:32:42+0000

You can probably use the operator not like

in this case:

$object = Related::whereHas( function($q)
{
    $q->where('URL', 'not like', 'http%');

)->get();

Reverse query with similar - laravel eloquent or raw MySQL query

More articles: