According to Mysql ref: if an ip is 220.127.116.11
The generated number is always in network byte order. For the example just shown, the number is calculated as 209×(256^3) + 207×(256^2) + 224×256 + 40.
To search subnet we need add relevant no # host data to the search.
for example to search 18.104.22.168/23
i need to convert the network detail to number - 3639557120
since /23 i need to add 512 to the network figure so 3639557632
Then if i could write the query .. like this works fine..
mysql> select dstaddr ,dpkts,srcaddr,srcport,dstport from Raw1253672304 where INET_ATON(dstaddr) > 3639557120 and INET_ATON(dstaddr) <>
May be there can be easy way.