CREATE TABLE name2ip (
          name   text -- don't make this a primary key!
          ip     text -- or inet, or whatever mySQL has
   );