TegRND
asked on
Need query to parse mysql table URL column for distinct ip and output grouped results.
Hello,
Please help me to construct the mysql query that will find all distinct ips from the URLs column and will group the results by these ips.
url column entry examples:
http://10.10.0.69/gate/profile.aspx?mop6LFfL0XU0MPpggZSBcSkazbVvGYNHBJsMsxb9X1Rn8m7+JB5hNiTKPIEJVdzDqK
http://192.168.11.7/sUtils/GetListing.aspx?Session_Info=CCeT/AvRx48puN1a8BbNekz72ToJW4KFnrIGwn1Mg9Injyw6V3
desired output:
Ip| count
TIA.
Joe.
Please help me to construct the mysql query that will find all distinct ips from the URLs column and will group the results by these ips.
url column entry examples:
http://10.10.0.69/gate/profile.aspx?mop6LFfL0XU0MPpggZSBcSkazbVvGYNHBJsMsxb9X1Rn8m7+JB5hNiTKPIEJVdzDqK
http://192.168.11.7/sUtils/GetListing.aspx?Session_Info=CCeT/AvRx48puN1a8BbNekz72ToJW4KFnrIGwn1Mg9Injyw6V3
desired output:
Ip| count
TIA.
Joe.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It was a pleasure. Cheers, Paul
ASKER