SQL syntax for manually deleting bounced users

[websites]

Hi Dean
Can you or anyone else help with SQL syntax to use in PHPMyAdmin - I think I have something wrong here:

I want to manually delete all the bounced users from List number 2 and tried to construct my SQL as follows:

DELETE * FROM `lm_users` WHERE cnf = '3' and list = '2';

But it is wrong somewhere as it stops at the *

Many thanks  

Regards
Andrew

[DW]

Hi Andrew,

The * is not required for  DELETE statements.  Simply remove it.  The rest of the query looks good but as always, be very careful with DELETE statements!

Regards