Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- phd_area_of_research_2 == Table name on which the operation needs to be performed
- area_of_research == column on which the search and replace should happen
- area_of_research = REPLACE(area_of_research, 'Math--', 'MATHS--');
- area_of_research = REPLACE(area_of_research, 'Search This', 'Replace with this');
- */
- UPDATE phd_area_of_research_2
- SET
- area_of_research = REPLACE(area_of_research, 'Math--', 'MATHS--');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement