Hello
> I need to be able to search (WHERE column LIKE 'search') in heading,
> body and/or author in all three tables, ORDER BY the latest date,
> and LIMIT 20.
MERGE table type is your friend, see section 8.2 of the manual.
Another possibility is to use a temporary table (CREATE TEMPORARY
TABLE tmp ...) where you would insert results of the three queries you
need (INSERT INTO tmp SELECT foo FROM bar1 ...) and then you would run
your final select from that temporary table, ordering results by date.
cheers
--
TS
---------------------------------------------------------------------
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
