SQL HELP

Im looking for someone to write me ONE sql query that UPDATES a field after checking a different Database for a certain input. I can prob Paypal you for your time, even though this will take someone who knows what their doing, 2 minutes. PM me or post for details?

ok!

its need to update ‘convert’ = 1 where ‘convert’ = 1 in database test2 table account.

im sure that makes NO sence..

It does.. but you’re changing the value convert to 1 where it is already 1?

UPDATE database.thisTable SET 'convert' = 1 WHERE id IN (SELECT id FROM database.thatTable WHERE 'convert' = 1)

Updates convert to 1 on thisTable where convert = 1 on thatTable. id is an identifying column shared by both tables.

Back up your tables, didn’t test this.

UPDATE database.thisTable SET 'convert' = 1 WHERE id IN (SELECT id FROM database.thatTable WHERE 'convert' = 1)

Updates convert to 1 on thisTable where convert = 1 on thatTable. id is an identifying column shared by both tables.

Back up your tables, didn’t test this.

hank, i love you man. Thanks alot, this got me on the right track.

Why not just check database 2 for the convert value in your script instead of database 1??

Reading the problem description has made me autistic.

Is this a thread you can delete without Pepsi getting mad??

such threads exist?