Do a myisamchk on your table. It sounds like you're having
trouble with a corrupted index.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -----Original Message-----
> From: John Wallace [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 24, 2001 05:56
>
> 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
