I've got a database having a table with 18 posts, the 2nd which is known as "desc". I wish to remove every row which has a certain value under "desc". I am by using this code:

DELETE FROM items WHERE desc='Swap this note at any bank for the equivalent item.'

By using this command within PHPMYADMIN provides me with this error:

#1064 - 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 'desc='Swap this note at any bank for the equivalent item.'' at line 1

I have looked around pretty much however i can't appear to locate what I am doing improperly.

mySQL version is 5.5, phpMyAdmin version is 3.4.5.

You will need to use backticks around desc because it is the keyword for climbing down order when utilizing ORDER BY:

DELETE FROM items 
WHERE `desc`='Swap this note at any bank for the equivalent item.' 

Spot the back ticks. desc is really a keyword in MySQL

DELETE FROM items WHERE `desc`='Swap this note at any bank for the equivalent item.'

desc is really a RESERVED WORD in MySQL

to be able to escape Reserved Words, you have to use back tick ( ` )

DELETE FROM `items` 
WHERE `desc`='Swap this note at any bank for the equivalent item.'