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
TABL
I have three tables of different data which I need to make a search in.
Every table has a column for date, heading, body and author.
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.
If I want to m
