Query the links Database

WordPress adds prefixes to tables names, which was setup on installation. So by default there is wp_ prefix for tables names. It means that by default table name for links will be wp_links. But you shouldn’t care about standard tables name, because all of them exists as parameters of wpdb class (read Table section), so your query should be built like this:

$sql = "SELECT * FROM " . $wpdb->links; 
$data = $wpdb->get_results($sql);

Related Posts:

  1. How to return number of found rows from SELECT query
  2. Can i use php sql functions instead of $wpdb?
  3. $wpdb->delete column values IN ARRAY()?
  4. How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
  5. Custom query to get post names beginning with a digit
  6. WordPress get pagination on wpdb get_results
  7. Ajax $wpdb not returning table data
  8. Converting MYSQL to WordPress $WPDB
  9. Why is variable not working on custom sql query using wpdb?
  10. Show MySQL errors that occur when I excute $wpdb->insert()
  11. Can’t get wp_insert_post to work
  12. WSoD being caused by this piece of code
  13. I want to select the from values from database in WordPress? [closed]
  14. Update results, Before deleting the related category [closed]
  15. wp query foreach deleting record returning only first or last item
  16. Database query works fine outside WordPress
  17. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  18. $wpdb->insert() does not Insert record in a table
  19. Help with a $wpdb MySQL Query
  20. Custom array from a query only write the last row of the query
  21. $wpdb returns duplicate posts
  22. Mixing variables into an array when inserting values
  23. Use $wpdb or other PHP script method to find/replace in WP database
  24. How can I add a new row in a separate database when someone registers via WordPress?
  25. Basic wpdb update question
  26. I can’t update my data through $wpdb
  27. Output: “Array”
  28. How to use mysql LIKE with wpdb?
  29. How do I prepare strings for insertions as values into a MySQL table?
  30. How to use AJAX in WordPress in MYSQL query?
  31. form $_post action value gets truncated after it passes through two forms
  32. Why won’t this wpdb get_results query return results?
  33. WPDB secure custom form
  34. Add row to custom database Table and delete all rows older than 1 day
  35. select a single val though a table in wordpress
  36. populate select options from extra mysql table data
  37. MySQL Query Returns Array () In Shortcode
  38. Passing in MySQL prepare statement parameter separately throwing error
  39. Convert a column of a table containing an Array as response in HTML
  40. Database SQL query error
  41. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  42. Conditional formatting on data fetched from MYSQL
  43. What is the correct way to search 3 custom fields only in WordPress?
  44. Using wpdb to connect to a different database is not working
  45. Rewrite SQL query as a prepared statement and use in foreach loop
  46. Advanced WordPress SQL Query
  47. MySQL query in WordPress with AJAX
  48. Passed variable gets undefined variable error on insert on next page
  49. MySQL queries in WordPress
  50. Using the same shortcode to show any table from the database
  51. MySQL database migration to WordPress
  52. MySQL update text field with ‘
  53. Error resetting database index using ALTER TABLE in $wpdb->query
  54. Putting form result in my database
  55. How can I update a value of a field depending on outside source?
  56. How to get the list of WooCommerce product image of a certain category from database?
  57. Changing user_nicename
  58. WordPress will not operate correctly
  59. tag search using WP_Query
  60. Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  61. if statement on database query
  62. Is the regular ajax request method safe or I should use admin-ajax.php?
  63. Sortable admin column for one meta key with three possible meta values
  64. WordPress Ajax Custom Query – High CPU LOAD
  65. AJAX in WordPress, sending coords data to MySQL and show after into map
  66. Styling images coming from another blog
  67. How to convert objects into arrays
  68. Is there a way to get 3+ dimensional array from a single MySql command
  69. How to insert a single row to WP database table?
  70. mysql query from wordpress page using custom table
  71. Importing Geo data into wordpress database
  72. PHP Fatal error: Uncaught mysqli_sql_exception: Table doesn’t exist in wordpress/wp-includes/wp-db.php
  73. How to check if a meta value has already been assigned to any user?
  74. Using custom tables for old posts
  75. Multiple meta_key in one global $wpdb;
  76. WordPress member notification
  77. Location of core code for database connection and get_header
  78. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  79. Most commented posts by time period (last 12h, last 24h and etc)
  80. How to get specific attribute from DB
  81. Hide posts if user is added to it WP_query
  82. How to unserialize data from MySQL
  83. PHP -> SQL Query with Summing
  84. How to insert wp_users ->user login name to wp_terms when a new user registering?
  85. Known Issues in WordPress When Upgrading PHP to ver 7
  86. Change MySQL PDO connection to a WPDB connection
  87. Get the id of the row from database on click of a button [closed]
  88. Call to a member function get_row() on a non-object, Unable to use global $wbdp inside a plugin
  89. Isn’t Returning Value While Using SELECT COUNT(*) FROM {$wpdb->prefix}
  90. Display Results of SQL Query on WP site
  91. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  92. How to display MySQL table data which is stored as an array?
  93. How to import woocommerce custom fields data into another site?
  94. 403 Forbidden WordPress Database Results
  95. At what point during a typical request does the $wpdb object become available?
  96. Let users register weight each day and save it in DB
  97. Fetching wpdb data from a php file seems to break?
  98. posts_clauses drop ACF get_field function
  99. I have an error WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version
  100. Function wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder