Laravel 5.3 query builder: 'NOTLIKE' not working

Question

I have a table that has a column named version that has four rows containing values

|Version |
|--------|
|5.3     | 
|5.2     | 
|5.3     | 
|5.2,5.3 |

I want to get rows that's values are not like 5.2 I mean, I want to get the first and third rows not second and fourth rows.

I used Eloquent Model 'Menu' to make the query as below.

$query = Menu:where('version', 'NOTLIKE', '%5.2%')->get();
$numberRows = count($query);

$numberRows equals to 0.

Am I in the right way? Or, is there any other way to do this? I need help.

Answer 1

Change NOTLIKE to NOT LIKE

Correct code:

$query = Menu::where('version', 'NOT LIKE', '%5.2%')->get();
$numberRows = count($query);