Hi!
First: please reply to the list, not directly to me.
Then:
I need a repeatable test case. That is
CREATE TABLE ...
INSERT INTO ... VALUSE (...),(...)...
SELECT * FROM ... WHERE ... <= it works
SELECT * FROM ... WHERE ... ORDER BY ... <= it does not
On Dec 04, Mark J. Degallier wrote:
>
> What other info do you need? The second query doesn't give me an error --
> it just returns an empty set.
>
> > > If I run this query it works:
> > > SELECT * FROM products WHERE (MATCH
> > > (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('anystring'))
> > >
> > > But if I run this query it does not:
> > > SELECT * FROM products WHERE (MATCH
> > > (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('anystring')) ORDER
> > > BY item_no
> > >
> > If you'll provide us with more info I'll be able to explain
> > what's going wrong.
> >
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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
