Where not exists help

[bslone12]

can anyone help me with why this isn't working

INSERT  into shows (title) 
values ('{"en":"Criminal Minds"}' ) 
where not EXISTS 
        (   SELECT  title
            FROM    shows 
            WHERE   title = '{"en":"Criminal Minds"}'   
                    );

I get this:

MySQL said:

#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 'where not EXISTS
        (   SELECT  title
            FROM    shows
      ' at line 3

[Barand]

INSERT statements don't have WHERE clauses.

 

If you don't want to allow duplicate titles, add a UNIQUE constraint to the title column