dimanche 4 juillet 2021

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax - Laravel [closed]

I have the following syntax error and I can't find the solution. Any help would be appreciated.

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'estado <> ?' at line 1 (SQL: select * from registros where Cancelado estado <> Terminado)

Query

$registros = Registro::where('estado', '<>', 'Terminado', 'Cancelado')
    ->get();


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire