Grouping mysql result as per arrey

[premishere]

i am using one database in mysql in which it is having a record of source IP(sip), destination IP(dip), source port(sport), destination Port(dport). when doing select query
(select count(sport) as port, sport from IPtable limit 20); the result is as this query states means port sport
3 | 80
5 | 8080
15 | 21
3 | 20
25 | 443
16 | 1234
49 | 2352
15 | 2353

i want to group these ports like

web (80, 8080, 443)
ftp (20, 21)
chat (2352, 2353)
others("rest other ports")

and want output result as

count | port

================

33 | web

18 | ftp

16 | application

64 | others

please help because i want to create pi chart from this output

[Rabbit]

First of all, your original SQL shouldn't have run, it's missing a group by clause.

Create a table that lists the port number with it's classification. Join that to your table on the port number and use the classification instead of the port number.