On 6/7/01 4:50 PM, "Eric Fitzgerald" <[EMAIL PROTECTED]> wrote:
> When comparing float values, you have to use '' around the value.
>
> Your query should look like this:
> select distinct sequence_id from sequence_protein where mol_wt = '53211.62';
Ok, I should have mentioned that I tried the quotes.
I am running out of ideas.
Hannes
mysql> select sequence_id, mol_wt from sequence_protein limit 1;
+-------------+----------+
| sequence_id | mol_wt |
+-------------+----------+
| 100368 | 53211.62 |
+-------------+----------+
1 row in set (0.02 sec)
mysql> select sequence_id from sequence_protein
-> where mol_wt = '53211.62';
Empty set (0.15 sec)
mysql> select sequence_id from sequence_protein
-> where mol_wt = "53211.62";
Empty set (0.16 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
