MySQL Query, please help

[globalwin]

I inserted these twice, so can anyone please tell me how to delete them?

INSERT INTO setting (settingid, settinggroupid, title, varname, value, description, optioncode, displayorder) VALUES ('', '6', 'Posts to change username', 'postuserchange', '50', 'Number of posts required for the user to change their own username within the user control panel. If you wish anyone to be able to change username set to 0.', '', '18');

INSERT INTO setting (settingid, settinggroupid, title, varname, value, description, optioncode, displayorder) VALUES ('', '6', 'Days between user change', 'dayuserchange', '7', 'Number of days between each time a user is allowed to change their nickname. If you wish the user to be able to change username at any time set to 0.', '', '19');

Any help appreciated, thanx. :tired:

[Chris M]

I think, but Im not sure, that you can delete them via phpmyadmin...

Satan

[Xenon]

DELETE FROM setting WHERE settinggroupid=6 AND title='Days between user change' AND displayorder='19' LIMIT 1

should be right, but using phpmyadmin would be better ;)

[globalwin]

thanx, sorted now :D