try;
select rticle, dealer, price from shop where price = '19.95';
notice the "'" around the value? :)
Hope that does it for you.
Atle
On Tue, 23 Jan 2001, John Wallace wrote:
> mysql> SELECT article, dealer, price
> -> FROM shop
> -> WHERE price=19.95;
> Empty set (0.00 sec)
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php