i have a table 'news' and i am trying to delete a row from it using something like this :

delete from news where index="12"

when i run that it gives me a syntax error at the index= section.

if i do select * from news where index="12" it does the exact same error.

my table looks like this :

+--------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------+--------------+------+-----+---------+----------------+
| index | int(11) | | PRI | NULL | auto_increment |
| author | varchar(50) | YES | | NULL | |
| title | varchar(100) | YES | | NULL | |
| data | text | YES | | NULL | |
| date | date | YES | | NULL | |
+--------+--------------+------+-----+---------+----------------+

and if i select * from news, the row with index 12 is:

| 12 | test | testing | testing | 2005-01-03 |


any ideas? i can select/delete based on other values just not index. is it maybe the fact that i named it index?

it's a numeric column, right?

try the query without the quotes around the 12

yes, index is a reserved word, so try it with backticks around the name

... where `index` = 12

yeah i tried it with/without quotes with no luck, but putting the `'s around it worked. thanks