Advertisement
mayankjoin3

MYsql Search and Replace

Oct 29th, 2022
1,483
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.42 KB | None | 0 0
  1.  
  2.  
  3. /*
  4. phd_area_of_research_2 == Table name on which the operation needs to be performed
  5. area_of_research == column on which the search and replace should happen
  6. area_of_research = REPLACE(area_of_research, 'Math--', 'MATHS--');
  7. area_of_research = REPLACE(area_of_research, 'Search This', 'Replace with this');
  8. */
  9.  
  10. UPDATE phd_area_of_research_2
  11.  
  12. SET
  13.  
  14. area_of_research = REPLACE(area_of_research, 'Math--', 'MATHS--');
  15.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement