deleting a group....?

[Drichek]

Hi guys,
I am using PHP and trying to delete all of the rows associated with a certain username. It's giving me an error.

// Deletes the user's characters from the Characters table...
$deletechars="DELETE * FROM Characters WHERE username='$myusername'";
if (!mysql_query($deletechars,$con))
{
die(mysql_error());
}

and it gives me error:

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 '* FROM Characters WHERE username='steve'' at line 1

Is this not the way to delete a group of certain rows from a table?
Thanks, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Thalian]

Remove the * from your query. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --