MySQL Datumsabfrage (spinnt!)

[Cheatah]

Hi,

SELECT Preis1
FROM   WH_Preis
WHERE ArtNr   = 'HDS5106'
AND GueltBis >= CURRENT_DATE
AND GueltAb  <= CURRENT_DATE;

was mir spontan einfällt: Kennt MySQL eigentlich BETWEEN?

...AND CURRENT_DATE BETWEEN GueltAb AND GueltBis

Was liefert bei Dir eigentlich CURRENT_DATE?

Cheatah