multi-table search

[bigodines]

Hi guys,

i´ve a search engine (very simple...) using mysql. But i´m using 1 table ... how to search in all tables of db?

(sorry about my bad english)

[csn]

With PostgreSQL you could probably use UNION, INTERSECT, etc.

Mysql? You're probably SOL.

Any any rate, sounds like a poorly designed db schema.

[dodga]

Just a sidenote: One can do JOINs and UNIONs in MySQL, too.
But without further information about your application (database schema, code, purpose, ...) there's no way to tell what exactly is not working

[asp_funda]

yeah, you need to tell what you are searching for. It'd be better if you post the structure of tables & tell what you want to search or on which columns of which tables you want to search.


Also, this thread should be in the DATABASES Forums.