MySQL - 1 Number Between 2 Values?

PHP
1

Hi Guys,

I’m having a little trouble trying to work the following out. In my database i have 3 columns, lets call them column1 column2, & column3. In column1 and 2 there are a bunch of unique number values for example 1000 in column1 and 1048 in column2. In column3 there will be text saying Virgin Broadband.

Now lets say i need to find out what the value of column3 is for number 1034. What SQL query would i use to find out that as 1034 is between 1000 and 1048 so it will say Virgin Broadband.

Any help would be great.

Thank you guys!

2 
SELECT column3
  FROM daTable
 WHERE 1034 BETWEEN column1 AND column2
3

Seemed simple enough, thanks a lot!

:slight_smile: