You could try: SELECT link, COUNT(link) AS count FROM table_name GROUP BY link
-- Rajesh Arun karthikeyan wrote: > Hi there, > In my table having 4 fields.That is > _id__|Link_________________ datano___________name| > 1 | jsg/jm/c=us&js |Mar 24|__________Katik > 2 | jsg/jm/c=eu&js |Mar 24|__________Katik > 32 | jsg/jm/c=us&js |Mar 25|__________Katik > 12 | jsg/jm/c=bs&js |Mar 24|__________Katik > 7 | jsg/jm/c=us&js |Mar 27|__________Katik > > My output will be....... > > us link Count > jsg/jm/c=us&js 3 > > jsg/jm/c=bs&js 1 > > jsg/jm/c=eu&js 1 > > That it ... can i check that 'c=' value that c in place of > anywhere in url.
