Hi!
On Nov 21, Mike Hunt wrote:
>
> All we want is for something like
>
> SELECT * FROM book WHERE MATCH(author) AGAINST
> ('stephen') AND MATCH(author) AGAINST ('king') LIMIT
> 100 /* these queries are ALWAYS limited like this */,
> a pretty normal kind of query, to return in an
> acceptable fast time; SELECT * FROM book WHERE
> MATCH(author) AGAINST (trollope') LIMIT 100 already
> does.
>
> It's certainly possible in some products - whether in
> MySQL or not is something I'd really like the answer to.
It's in MySQL since 4.0.1 only :-(
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