mysql - finding values between given inputs using sql -

am curious there way extract specific elements database in specified range based on 2 inputs. ex: select books minimum price = 10 , maximum price = 35, using mysql?

you can use select find rows values in ranges. example:

select * books  price >= 10 , price <= 20; 

or may use between instead:

select * books  price between 10 , 20; 

both queries above return rows price between 10 , 20.