Allow author of accepted answer to delete it in certain circumstances
I gave a quick aswer to a question that, while it works, allowed the potential to have SQL injection attacks.
As the original poster was trying to use string substitution for an
UPDATE, and I haven't used that backend (there are some DB backends in Python that use different placeholders) I showed how the string replacement should be done, with a comment that it shouldn't be used in production.
Pretty soon someone gave a better answer, to which I left a link in a comment in my own answer, and was upvoted over mine.
But the OP accepted mine, wich, with justice, warranted a small flood of downvotes. As I couldn't delete my accepted answer, I decided to include the correct answer with further explanation of why not to use the other way.
What this the correct thing to do? Was there anything else I could do?