How do I add an index when adding a new field?

Hi,

I would like to add an index as well as the new field.

I tried this, but it failed:


$sql = "ALTER TABLE `clients` ADD `new` char(1) NOT NULL default 'y',
KEY `new` (`new`)";

$result = mysql_query($sql)
or die("could not ALTER clients.". mysql_error());


Can anyone please help me get it right?
Thanks

ALTER TABLE `clients` ADD `new` char(1) NOT NULL default 'y' , ADD INDEX ( new)

Thanks for help :thumbsup: