title: SQL script to rename all the table names with new name if it containes required string in mySQL and MsSQL
body: <p>I have one database with 100 tables in it. out of 100 some tables have name like <code>House, House1, House2 , HouseXYZ</code> and so on.   </p>
  
  <p>Now I want to write a script in MySQL and MsSQL to replace the <code>House</code> with <code>Home</code>. So my database should be having the table name <code>Home, Home1, Home2, HomeXYZ</code> and so on.</p>