ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: websites on August 27, 2008, 02:39:05 am

Title: SQL syntax for manually deleting bounced users
Post by: websites on August 27, 2008, 02:39:05 am

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

Title: SQL syntax for manually deleting bounced users
Post by: DW on September 07, 2008, 08:28:34 am

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