Re: [PERFORM] Filter certain range of IP address.

[David G. Johnston]

On Fri, Apr 7, 2017 at 8:18 AM, Dinesh Chandra 12108 <
dinesh.chan...@cyient.com> wrote:

> Dear Vinny,
>
> Thanks for your valuable replay.
>
> but I need a select query, which select only that record which starts from
> IP "172.23.110" only from below table.
>
> xxx     172.23.110.175
> yyy     172.23.110.178
> zzz     172.23.110.177
> aaa     172.23.110.176
> bbb     172.23.111.180
> ccc     172.23.115.26
>

​SELECT ... WHERE substring(ip_addr::text, 1, 10) = '172.23.110'

David J.
 ​