unable to replace or remove some word in mysql column [closed]

i want to remove some string like Catering Tourism & Hotel Management ( PDFDrive.com ) i want to remove the pdfdrive.com from the string . how to replace or remove the string

via Chebli Mohamed