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. Fatal error: Call to undefined function mysql_connect()
  57. Query both first_name and last_name from wp_usermeta at the same time
  58. How to add query vars with paginated URLs?
  59. How to Join two tables from separate databases within WordPress
  60. simple wordpress ajax plugin not working when not logged in
  61. Install will not load: PHP does not have MYSQL installed
  62. Insert post without actions/hooks
  63. Import 10,000 Users into WordPress WITH a specific ID for each user
  64. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  65. How to get the post_id from postmeta
  66. register_activation_hook isn’t adding table to DB
  67. Query String being Removed Creating a Pagination Issue within a Custom Plugin
  68. How to Fetch values from WP database based on selected option value by onchange using PHP?
  69. Custom Plugin For Converting CSV To MySQL
  70. Checking for new message using AJAX and PHP. Server overload?
  71. Trying to establish connection to External Database
  72. $wpdb->update with multiple parameters gives error
  73. inserting a post from an extern php file but post content doesn’t show on wp site
  74. $wpdb->wp_users returning empty value for
  75. Force Users To Relogin
  76. how to get serialized post meta
  77. A $_POST should occur when submit form but is not?
  78. Pull MySQL data from multiple tables and merge into 1 PHP array
  79. Using CFDB7 vs Custom MySQL Database [closed]
  80. Adding data to custom wordpress database table
  81. Undefined variable: row?
  82. Using Ajax to submit a form, and run a SQL Select query based on user input from the form
  83. WordPress low speed after migrating to new host
  84. AWS Lightsail WordPress – connect to database on instance using mysqli
  85. call to undefined function mysql_connect
  86. How to edit content in WordPress and the Polylang – plugin? – with demosite
  87. Looping through custom data in a custom table to display all items in a post
  88. Insert data from form to database
  89. Prepared DB Query from _POST array
  90. Conditional statement within WP SQL query
  91. Run insert if no entry otherwise run update with ajax
  92. WordPress upload images not displaying
  93. two wordpress sites, two themes, one database, same content
  94. how to check for wordpress Query errors
  95. Custom query_posts() parameter
  96. Query Concatenation
  97. Display total count of products in orders of a specific order status
  98. how to display tables via ajax
  99. WordPress / PHP: Check if column has value and then check if value in array
  100. Can’t insert into a database wordpress