Hello all, I'm trying to query a database of speed test results for display on a php page. The results are fully-qualified machine names, often very long. What I'd like to do is trim it down so only the main domain name is left for display: for example, '68-65-69-187.vnnyca.adelphia.com' becomes just 'adelphia.com'. The problem is there is a more or less random amount of stuff to the left of the goodies I actually want. So...is there an easy way to just grab the two right-most bits between the periods?
Thanks bunches! Dan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]