mySQLi statement for multiple databases

[TapeGun007]

I have mySQLi statement that looks similar to this:

$sql = "SELECT  ID, FirstName, Last Name, Email, Mobile, PromoCode 
            FROM table1
            WHERE (Email LIKE ?)
            OR (Mobile LIKE ?)
            OR (PromoCode LIKE ?)
            ";

    $stmt = $consd->prepare($sql);

    $stmt->bind_param('sss', $Search,$Search, $Search);

 

Works fine.  But what I cannot seem to find is what if I had two databases with all the same tables and I want to query both of them using mySQLi?

 

I've tried all types of things, but I *think* because it's older mysql code that I'm not getting the syntax quite right...

[ginerjm]

Do you mean query them together? Or do separate queries on each?

[Barand]

Prefix the table name with the database name

$sql = "SELECT  ID, FirstName, Last Name, Email, Mobile, PromoCode 
            FROM database1.table1
            WHERE (Email LIKE ?)
            OR (Mobile LIKE ?)
            OR (PromoCode LIKE ?)
        UNION
        SELECT  ID, FirstName, Last Name, Email, Mobile, PromoCode 
            FROM database2.table1
            WHERE (Email LIKE ?)
            OR (Mobile LIKE ?)
            OR (PromoCode LIKE ?)
            ";

Databases must be on the same server.

[Jacques1]

if I had two databases with all the same tables

 

Why on earth would you have that?