iF ELSE END IF

[Michael Smith]

I am trying to check for the word 'Total' in a particular column and add a row if necessary.

Here's what I have tried:

SELECT COUNT(ITEM) FROM products01 AS V1 WHERE ITEM = Total';
IF (V1 = 0) THEN
INSERT INTO products01 (ITEM) VALUES ('Total');
END IF;

This statement generates a lot of error messages.

What am I doing wrong?

Mike