Querying multiple databases at once

by 
SELECT option_value
 FROM `database1`.`wp_options`
  WHERE option_name="active_plugins"
UNION
SELECT option_value
 FROM `database2`.`wp_options`
  WHERE option_name="active_plugins"

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  3. Compare two MySQL databases [closed]
  4. MySQL – Trigger for updating same table after insert
  5. How do I get the current time zone of MySQL?
  6. Storing image in database directly or as base64 data?
  7. Pass array to MySQL stored routine
  8. What does the KEY keyword mean?
  9. How to select from MySQL where Table name is Variable
  10. How to store a datetime in MySQL with timezone info
  11. MySQL utf8mb4, Errors when saving Emojis
  12. How to store unicode in MySQL?
  13. mysql after insert trigger which updates another table’s column
  14. Error Code: 1406. Data too long for column – MySQL
  15. Search for string within text column in MySQL
  16. How to export a mysql database using Command Prompt?
  17. How to pass parameters to mysql query callback in nodejs
  18. MySQL Incorrect datetime value: ‘0000-00-00 00:00:00’
  19. Clear MySQL query cache without restarting server
  20. Checking a table for time overlap?
  21. Does mysql have the equivalent of Oracle’s “analytic functions”?
  22. Mysql insert into 2 tables
  23. MySQL UPDATE and SELECT in one pass
  24. where does MySQL store database files?
  25. MySQL: How to retrieve a random row or multiple random rows?
  26. Correct way to keep pooled connections alive (or time them out and get fresh ones) during longer inactivity for MySQL, Grails 2 app
  27. MySQL: Setting sql_mode permanently
  28. MySQL: how to index an “OR” clause
  29. Is it possible to count two columns in the same query
  30. mySQL regex in the where clause

Leave a Comment