MySQL insert query error

Question

Whats wrong with this query. I'm getting an error saying

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Item 1') where ItemName like 'Item 1' at line 1

My query is

insert into newitem (QuantityAvailable) values 
(Select count(*) from  addtoinventory where ItemName like 'Item 1') 
where ItemName like 'Item 1'

Answer 1

insert into newitem (QuantityAvailable) Select count(*) from addtoinventory where ItemName like '%Item 1%'

Answer 2

Take out the word values from your query.

Also, I don't see what you expect the where clause to do in the outer query. If you haven't inserted a value yet, how can you compare it to anything? If you have, then the inner where clause takes care of that.