Does MySQL have built in function to get host name?
Similar to
select user(); //this returns user@userip
Edit:
select current_user(); //returns [email protected].%
Last symbol is %
-- why?
SELECT @@hostname;
--mysql 4.1 didn't have this one.