Keep your married friend as a friend and do not destroy a relationship built up over time.
If you are single go out and meet someone with like interests.
If like the rest of us you are already in a relationship share this with your SO.