On Fri, Feb 23, 2001 at 03:05:19PM -0500, Sander, Ryan wrote:
> I doing a newspaper site. My database has a different table for each
> category (local, sports, etc). All of the columns are the same for each
> table (Headline, byline, body, etc). Is there any way to search all of the
> tables at once (since they all have the same columns)?
>
> To further illustrate. If a user is searching for a story with the
> headline "The Headline" and they don't specify a category, then I have to
> search each table for that headline. Is there an easy was to do this or do
> I have to do a different search for each table?
>
If they are defined identically (i.e. fields and indices) you can
use a merge table for this (since MySQL 3.23.x).
> I have looked through the archive and manual with no success. Any
> suggestions would be appreciated.
>
Look up MERGE tables for more information.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
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