|
|
Posted by Anze on 09/29/05 00:41
Hi all!
I have a MySQL database that contains URLs and would like to fetch different
domain names from the field. Is there some sort of regular expression match
function? I need something like:
SELECT REGEXP('^(http://)?([^/])+/.*$', t.url, '$1') FROM my_table t;
That is, I need some sort of string function that would return a part of the
string based on a regular expression match.
Am I missing something? I looked around but couldn't find it. It looks very
basic stuff to me, there must be something like that out there?
Any advice would be welcome.
Kind regards,
Anze
Navigation:
[Reply to this message]
|