On Fri, Apr 7, 2017 at 11:29 AM, David G. Johnston < david.g.johns...@gmail.com> wrote:
> 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' > or select ... where ip_addr << '172.23.110/32'; if ip_addr is an inet data type -- https://www.postgresql.org/ docs/9.6/static/functions-net.html
