Has anyone here had a root canal and how was it?

Yes and the answer is it depends on whether your dentist is good and gives you enough anaesthetic. If you feel any discomfort tell them you want more anaesthetic, do not take no for an answer. You should feel nothing.