Regular Expression in MySq 'SELECT' query

Databases
1

Hi!
I have following regex in PHP :


$url = 'http://www.google.co.uk/webmail/';

preg_match("#^(?:http://)?(?:www\\.)?([^/]+)#i",$url, $matches);
echo $host = $matches[1];

How can I implement/convert above mentioned regex in Mysql ‘Select’ query, so that I shall be able to match/find only and only domain names from stored records of table.

Thanks in advance