CODEWITHSUNDEEP
phpmysqlsqldatabaserange
Waqar Sabir
Waqar Sabir

Reputation: 41

Selecting a row where range lies between two columns in mysql

I have 4 columns in my table

id , amount_from, amount_to, amount

My value is lets suppose 350000

The data in the table is:

image of table data

i want to query which column have a amount_from greater then 350000 and amount_to less then 350000

select * from table where id = 5 and amount_from >= 355000 and amount_to <= 355000

but i am getting 0 results.

Upvotes: 0

Views: 533

Answers (1)

Md Rasheduzzaman
Md Rasheduzzaman

Reputation: 1

Normally you would use the keyword 'BETWEEN'

SELECT * FROM table WHERE id=5 AND 350000 BETWEEN amount_from AND amount_to

Upvotes: 4

Related Questions