i dont know if im even going about this the right way, but heres what i am trying to do:

mysql> CREATE TABLE tbl_articles (
-> articleID INTEGER AUTO_INCREMENT PRIMARY KEY,
-> issue VARCHAR (20),
-> authorID INTEGER INDEX,
-> catID INTEGER INDEX,
-> subcat VARCHAR (50),
-> title VARCHAR (50),
-> subhead1 VARCHAR (100),
-> subhead2 VARCHAR (100),
-> specs TEXT,
-> body TEXT
-> );

but then i get this:

ERROR 1064: You have an error in your SQL syntax near 'INDEX,
catID INTEGER INDEX,
subcat VARCHAR (50),
title VARCHAR (50),
subhead1 VA' at line 4


Obviously i want to use the authorID and catID fields as an index. What am I doing wrong?