Maybe this question exists, but I couldt find it so you can also just link me to a similar question. My problem: I have a database and wand to visualize it with Grafana. In Grafana you have the option to create a query in SQL notation. In my case I want to count the similar IP addresses I have in
Tag: ip
DB | Postgres | How to check if IP is in a list of IPs or a range
I have a table that has a TEXT column that holds IP, IPs or range (for example 1.1.1.1/24). In case of multiple IPs, the IPs will be separated by a @##@ for example 1.1.1.1@##@2.2.2.2 The table with 4 rows: I want to get all the rows that contain the ip 1.1.1.1 or 3.3.3.3, meaning I want to get the first