Re: Advice on searching multiple tables..

Greetings, Chad! Urgh... This sounds like we have a REALLY S**TTY database design here... Can you be a lil' more specific about what do you store in this tables and why the hell you have to search ALL OF THEM? At 14.08.2000, 10:54, you wrote: CD> Looking for a good way to do this.. I can think of an ugly way, but it CD> doesn't seem too efficient. CD> I am getting one value from a form and I need to search multiple tables to CD> see if this field matches.. the tricky part is I need to basically search CD> all the columns in all the tables for this value, and the column names CD> obviously aren't the same, and some tables have 5 columns, some have 15. CD> The ugly way I can think of is just one damn long mysql query, but that CD> seems like it would be REALLY slow. The other way I can think of is doing X CD> # of searches, where X is the number of tables.. so if I had 5, do 5 CD> different searches. -- Yours, Alexey V. Borzov, Webmaster of RDW