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
+-