[RESOLVED] Searching Multiple Databases

middleman666

Hey people,
hope you are all well.

Having a bit of a hard time getting my head round how to search multiple databases.
I've looked into the UNION function, but from my understanding (and please correct me if im wrong) you can search multiple databases but only if you have a field in each database that has the same name. e.g.

SELECT E_Name FROM TABLE01
UNION
SELECT E_Name FROM TABLE02

I was just wondering, would it be possible to do something like this:

SELECT * FROM TABLE01 LIKE \"%$SearchInput%\"
UNION
SELECT * FROM TABLE02 LIKE \"%$SearchInput%\"

if not, is there any other way of searching all the fields from multiple databases?

thanks for any help.

bogu

To search in multiple DB u need to open connection to one of the DB make the search, close the connection, open another conection to the other DB make the search, close the connection, and so on ...

To search in multiple tables, u can use UNION ...

SELECT * FROM TABLE01 LIKE "%$SearchInput%\" 
UNION 
SELECT * FROM TABLE02 LIKE \"%$SearchInput%\"

This will work if the tables are in the same DB and the number of fields and there names are the same ...

middleman666

Sorry, I meant multiple Tables not multiple databases :S

Trouble is, the number of fields and their names are not the same in all the tables.

Is there a way round this? so I could search all the tables in one big query?

bogu

Cant help u more if I dont know how your tables look like and how u what to make the search, but u could look into JOIN-ing the tables ...

middleman666

sorry, heres more info.
These are two of my tables, both in the same database

BlogTable
id int not null primary key auto_increment,
Date date,
BlogTitle text,
Blog text

NewsTable
id int not null primary key auto_increment,
Filename text,
Date date,
Title text,
News text,
User text

Been fiddling round with the code and I tried the following:

select Title, id from NewsTable where Title like \"%$SearchInput%\"
UNION
select BlogTitle, id from BlogTable where BlogTitle like \"%$SearchInput%\"

that seems to work... so I think i'm happy for now 🙂

Thanks for your help.