[support] How to replace page old links with new drupal node in batch mode?

Hi All, I am new to Drupal, I have created drupal page nodes and manually copied and pasted my old html content into the page nodes. There a lot of those pages nodes with some old html links in in them. It is very inefficient to edit them hand by hand, I am wondering if there is a way to do "match and replace" those old links with drupal page node automatically either by coding some script or SQL query and replace. Vincent TIA