Skip to content
Advertisement

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.

https://gyazo.com/c85bfb44ccb326ac2f0c6652391e327e

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

Advertisement

Answer

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
Advertisement