fenway

What does it do currently?

Unless that's part of the design.

How?

Huh?

Please post the query and EXPLAIN on *this* forum...

Then magic quotes is probably also at play.

I'm still confused... why not just import that table?

Yup.

Use an IF() to catch this.

Describe both source & target db.

You don't *need* to at all.

You're not connecting as root... as the error message says.

I'm not sure how you mean.

Echo the sql queries.

You mean into different tables, thn.

Interesting... and if you switch it to just an index on the e-mail, do you then get index_merge? I'll have to check it on my box later on tonight.

Hmmm..... did you select a DB?

Switch this to a LEFT JION.

But INSERT can have multiple VALUES() clauses....

Post the table structure and EXPLAIN output... I'm looking for index_merge.

First, that's updating, not insert... you can definitely insert multiple at a time

Better yet, echo the actual query.

Which version of MySQL are you using? It won't use the index because it's an OR.

You'll likely need to use a subquery.

Try this: select i.imageFilename from images_table as i inner join network_table as n on ( n.userId = i.userId and n.networkId = 1 ) where i.imageType = 'photograph'