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

##</code><code>##

   SELECT ip FROM name2ip WHERE name = somename;

##</code><code>##

   SELECT name FROM name2ip WHERE ip = someip; -- or, LIKE blah or whatever