|
|
Posted by Anze on 09/30/05 01:26
Please, anyone? Is it possible? I really need this...
Kind regards,
Anze
Anze wrote:
> 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]
|