In our database field name conatains Mr. Mrs. Miss ect which we want to remove thru query

Please help me in writing such query