If somebody interested I've got a solution:
SELECT count(*) as quan, SUBSTRING(r_js, 1, locate('/', r_js, 8)) as a FROM
main where length(r_js) group by a order by quan desc;
On 04-Oct-2001 [EMAIL PROTECTED] wrote:
> Hi there!
> I have a varchar(255) row in a table, that contains some URL f.e.
>
Excuse me for putting confirm reading flag ON.
On 04-Oct-2001 [EMAIL PROTECTED] wrote:
> Hi there!
> I have a varchar(255) row in a table, that contains some URL f.e.
--
Ruben Muradyan
System Administrator/Security Manager
PanARMENIAN Network
+-
Hi there!
I have a varchar(255) row in a table, that contains some URL f.e.
http://www.somehost.net/eng/headlines/cache/699.htm
I need to cut the first (http://www.somehost.net) part from this URL.
After looking at regexp realization in MySQL I've written
SELECT r_js REGEXP "^[http://./]"; as
