How do you run a SQL query on a certain database without "selecting" it first?

[Ashleyuk1984]

How do you run a SQL query on a certain database without "selecting" that database first...
All I want to do is go straight to SQL and perform the query.
Server has multiple databases...

This is the query that I'm trying to perform.

UPDATE wp_posts SET post_author=1 WHERE post_author=0

I've tried:

Select [I]DatabaseName [/I]UPDATE wp_posts SET post_author=1 WHERE post_author=0

But that didn't work?

 

[Firecooler]

UPDATE databasename.tablename

in your case UPDATE database.wp_posts

 

[Ashleyuk1984]

Perfect RapidVideo.
Thanks !