Access Tables with number prefix

When in multisite, the wpdb prefix is always the prefix required to access the tables for the current site. This includes the site ID

so this should work:

$wpdb->get_results($wpdb->prepare("SELECT * FROM ".$wpdb->prefix."options WHERE ....."));

There should be no difference at all when using multisite, just make your queries as if it were single site.

Related Posts:

  1. simple sql query on wp_postmeta very slow
  2. How many WordPress SQL Queries per page?
  3. Multipart/formatted MySQL query problem
  4. Are database queries created using WordPress filters protected from SQL injection?
  5. Grouping related postmeta data via SQL query
  6. Mysql / WordPress killing my server with 80k users [closed]
  7. Slow meta_query with about 4 milion record on wp_postmeta
  8. Select User by Joining Multiple Meta Value Results
  9. mySQL query. ORDER BY meta_key
  10. Update slug (URL) of pending posts via phpMyAdmin
  11. My SQL function to change user_name
  12. You have an error in your SQL syntax – Help with query
  13. MySQL variable in query
  14. how would I create a custom query to get all users, and a related post based on a postmeta field?
  15. Help with MySQL to $WPDB query
  16. SQL query to select posts from multiple categories
  17. How do I see the mysql query generated by get_posts( $args )?
  18. Alter query with posts_clauses to retrieve NULL values last
  19. MySql Query very slow
  20. Searching With Apostrophe
  21. WordPress Query wp-terms SLOW
  22. wpdb COALESCE won’t work
  23. Get posts from category with custom query
  24. how to insert missing tags into the posts through mySQL?
  25. Ideas how to search & replace post_content when string contains a newline?
  26. Valid SQL query return empty
  27. mysql query – how to escape apostrophe?
  28. Query the WordPress database to get data together with replaced information
  29. Optimize slow SQL query for multiple meta values
  30. Updating with $qpdb->query() always returns 0 rows affected
  31. How to return count of custom post type posts with a specific custom field value via $wpdb?
  32. WordPress Mysql query and Duplicate
  33. Help with Related Posts Function
  34. How to delete all images from code in all post_content
  35. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  36. Displaying data from custom table
  37. Get 2 meta values from meta key column
  38. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  39. SQL query to delete users with multiple meta keys and comments
  40. OR condition not working
  41. Trouble migrating custom post types from non-wordpress cms
  42. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  43. Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
  44. How to make MySQL search queries with quotes
  45. Custom MySQL Query for Post and Post Meta
  46. Mysql query and odd results
  47. sql for querying post and their category
  48. Search and replace text across all posts
  49. wp_dropdown_categories with multiple select
  50. How to tune search argument in WP_Query to show only exactly the same results?
  51. How to get my loop to pull posts into three columns
  52. Custom $wpdb Query for Custom Post Type by Category
  53. Can’t pass table to $wpdb->prepare
  54. Date query year and month OR just year
  55. get post id using the $query_vars variable
  56. Calculating Bayesian average for custom post type
  57. Disallow categories from this MySQL query
  58. How to check current user in meta value array in WP_Query meta_query
  59. How select a specific query when setting offset?
  60. Change media attachment author via mysql query
  61. sql select query in wordpress ‘page’ [closed]
  62. wpdb->term_taxonomy count posts from both published and private posts?
  63. How to get related tags based on a category?
  64. Attempt to improve WP search, can someone check my SQL query?
  65. WordPress Query orderby title with UTF8 string in title
  66. Query multiple tables at once?
  67. get_posts showing only 5 posts. (nopaging and posts_per_page -1 not working)
  68. Custom WordPress Table wpdb
  69. Order by title – but now built in wordpress func, sort the_title
  70. Display posts between two particular dates
  71. Order posts by date, but also give priority for a specific term
  72. $post->ID not working in combination with a custom query
  73. Update query for wp_posts and wp_postmeta
  74. Combine “Exclude” Query in functions.php
  75. Wrap/close ‘query’ for a first-letter ordered listing of posts
  76. wpdb query with dynamic column name?
  77. How do you display the number of a post in a query?
  78. How can I get the name of term post meta value which equals term id
  79. Trying to use WP_Query to return post with and without meta values
  80. get products by custom date variable
  81. How to sort by two meta keys in admin area?
  82. Restrict WordPress search to a single ACF field
  83. wp query multiple values > display a specific value first
  84. Nested select statements not working
  85. Pagination adds search query (again)
  86. Fastest and most efficient SQL query to check if UID exists
  87. Counting And Monitoring How Much Queries My Script Used
  88. How can I display a query in a page?
  89. Function returning queried meta value based on current post ID
  90. search.php is not generating the right results
  91. Slow query when joining wp_posts with a lookup-table?
  92. Filter the feed page post limit
  93. Using wp_list_table how to trigger update function “inline”?
  94. Modify Global Posts Plugin
  95. How to reference same column name but different table in custom db query
  96. Retrieving custom field array value through db query
  97. Query Concatenation
  98. How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
  99. update $wpdb one query
  100. How to use a dynamic term id for the query block