[Swedie]

Originally Posted by MarcoH64

Well this would only delete a row if in 1 row the field 'varname' would have the value 'setting_allowguestbook_desc' AND 'setting_allowguestbook_title' AND ..... at the same time.

This will never be the case.

Think you might be better of replacing those 'AND's by 'OR'.

oh crap! that's right. Sorry oldfan. This is what it should look like:

DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' OR varname = 'setting_allowguestbook_title' OR varname = 'setting_allowwebpage_title' OR varname = 'setting_allowwebpage_desc' OR varname = 'settinggroup_guestbookwebpage' OR varname = 'setting_webpagevbcode_desc' OR varname = 'setting_guestbooksmilies_desc' OR varname = 'setting_webpagevbcode_title' OR varname = 'setting_webpagesmilies_title' OR varname = 'setting_guestbooksmilies_title' OR varname = 'setting_webpagesmilies_desc' OR varname = 'setting_webpagehtml_title' OR varname = 'setting_webpagehtml_desc' OR varname = 'can_use_guestbook' OR varname = 'can_use_webpage' OR varname = 'setting_allowedhtmltags_title' OR varname = 'setting_allowedhtmltags_desc' OR varname = 'edit_webpage_content' OR varname = 'edit_guestbook_settings';