Sql query to get the row if user ip in between column[ipfrom and ipto] of database

Asked May 30 '22 at 09:31

Active May 30 '22 at 11:23

Viewed 24 times

I have database table alike

id   ipfrom    ito        country     code
1    1.0.0.0   1.0.0.255  Australia   AU
2    1.0.1.0   1.0.3.255  China       CN

I have multiple rows in table around 12500 data.

I need sql query to get the row if user ip in between ipfrom and ipto of any row.

Example:

If i request for ip - 1.0.0.1 then it must return first row as shown in above table.

Updated:

I am using mysql

edited May 30 '22 at 11:23

jarlh

asked May 30 '22 at 09:31

Suresh Chand

Which DB do you use? Did you search for that in the net? There are useful articles like https://www.sisense.com/blog/comparing-ip-addresses-in-sql/, didn't they help? – Jonas Metzler May 30 '22 at 09:45
I am using mysql – Suresh Chand May 30 '22 at 09:47
So this doesn't work?: https://stackoverflow.com/questions/24179437/mysql-check-if-an-ip-address-is-in-range – Jonas Metzler May 30 '22 at 09:52

0 Answers0