Skip to content

My SQL is have to search for articles in my database within price range of 3,00 and 4,00 but the code does not work

Cam someone help me….

I have to bookmark my SQL Query, i have to create a code to boormark all products within the tabel “album”, and the price must be between 3,00 and 4,00 But it doesnt work. Can someone tell me whats wrong?

Im new in SQL so sorry if its a dumb qeustion xD

Screenshot of the code down here.

SELECT * FROM `album` WHERE prijs BETWEEN 3,00 and 4,00;



asuming prjis is a valid number data type don’use comma for decimal

select * from  album where prjis between 3.00 and 4.00;
8 People found this is helpful