Atle,
I have tried all varieties of syntax, including using some conversion
functions. This is such a fundamental operation and so simple there is
obviously something not working properly. I am familiar with SQL from SQL
Server on NT but am evaluating mySQL and am thwarted by this simple failure.
See additional queries at the end of this message. Thank you for replying!
Regards,
John Wallace
----- Original Message -----
From: "Atle Veka" <[EMAIL PROTECTED]>
To: "John Wallace" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, January 23, 2001 8:16 PM
Subject: Re: newbie question re: manual tutorial
>
> try;
>
> select article, dealer, price from shop where price = '19.95';
>
> notice the "'" around the value? :)
>
> Hope that does it for you.
>
>
> Atle
>
mysql> select * from shop;
+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
| 0001 | A | 3.45 |
| 0001 | B | 3.99 |
| 0002 | A | 10.99 |
| 0003 | B | 1.45 |
| 0003 | C | 1.69 |
| 0003 | D | 1.25 |
| 0004 | D | 19.95 |
+---------+--------+-------+
7 rows in set (0.01 sec)
mysql> select * from shop where price='19.95';
Empty set (0.01 sec)
mysql> select * from shop where price="19.95";
Empty set (0.01 sec)
mysql> select * from shop where price>10;
Empty set (0.00 sec)
mysql> select * from shop where price>'10';
Empty set (0.01 sec)
mysql> select * from shop where dealer='B';
+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
| 0001 | B | 3.99 |
| 0003 | B | 1.45 |
+---------+--------+-------+
2 rows in set (0.01 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
