Of course. However, this is time consuming and most people don't have libraries built up that contain the content for quick access.
I'm thinking more about something like The Daily Show, SNL, or any late night TV show. I can't imagine that they're manually doing all this work independently.
Perhaps there are databases made available to them through a third party or perhaps their production companies?