Prince Andrew is giving up his titles, including the Duke of York, he has announced in a personal statement.