Phpmyadmin – post editing

Mysql allows you to run queries that apply to all post, see example :

UPDATE wp_posts SET POST_CONTENT = replace(POST_CONTENT, '<a href="http://mysite.com/my_link">mylink</a>', '');

This code allows you to delete <a href="http://mysite.com/my_link">mylink</a>on all posts. But in your case I doubt all links are the same so you need a pattern. Perhaps it can be done with [REGEXP].1

Do you need to delete all links in content? That would be easier.

EDIT: make a backup of your database before anything !

Related Posts:

  1. How to clear the cache?
  2. How to do a query only on a specific admin page?
  3. WP_Query pagination not working in admin area
  4. Use ‘parse_query’ filter to show posts that from multiple criteria
  5. hide custom post types with specific meta key ON admin backend
  6. WP CLI can’t delete plugin related table
  7. How to view all posts of current day as default in admin
  8. Admin: Custom Query Returning Permissions Error
  9. WordPress AJAX Request returns 400
  10. How to use custom page for all posts with custom url, call another directory?
  11. Is it possible to give a classname to specific comments in the WordPress admin?
  12. How to set selected attribute on option after filter query?
  13. Filtering custom post type list in admin by custom meta key/value
  14. How to store and receive variables in WP sessions?
  15. Nested meta_query with multiple relation keys
  16. WP_Query vs get_posts
  17. Query Multiple Post types each with own meta query
  18. How-to exclude terms from the main query the most performant way?
  19. Pagination with WP_Query is buggy – working for some pages, but not the others
  20. Display only posts with thumbnail using WP_Query
  21. Why is my WP_Query not working when tax_query terms are an array?
  22. Make First post different from rest?
  23. pagenavi with merged wp_query [duplicate]
  24. How can I display recent posts from a particular category in my header?
  25. Search Custom Post with meta_value NULL
  26. Ajax Infinite Scroll In Custom WP_Query Loop Not Working
  27. Query two post types and order by two different date fields
  28. Injecting content with $wp_query->current_post restarts from zero on paged pages. How to inject content after X posts, regardless of pagination?
  29. Find all product that contain terms with %keywords% in WP_Query
  30. WP Query – Get WooCommerce Products with variation that is in stock
  31. Multiple search queries on one page
  32. Filtering WP_Query result by category
  33. posts order by title second word
  34. Merged two WP_Queries, posts per page and pagination not working
  35. Why WP_Query::is_date() returns false when ‘date_query’ argument is set?
  36. Custom Post order for homepage
  37. Arrange BBpress topics by created
  38. Query all posts in a given taxonomy
  39. Warnings in nav-menu when visiting query pages [closed]
  40. Page navigation doesn’t show when query category
  41. Create ONE callback for all page templates, post filter queries + paginated pages, triggering pagination via AJAX
  42. Sorting posts DESC based on the number of comments using WP_Query
  43. Create unique page without header.php for json feed
  44. get_posts() not working with multiple statuses
  45. Unexpected end of file
  46. WP_Query To call data from diffrent tables
  47. Performance when getting post meta for post retrieved by meta value
  48. Clean up WordPress code that repeats
  49. WP_Query: “post_parent” and “post_type” combination returning strange results
  50. How to use the query hook/filter?
  51. WP_query return more results than SQL query. post_count > found_posts
  52. How do I exclude the lowest level terms in a taxonomy?
  53. Stale $GLOBALS[‘post’] after custom WP_Query empty result set bothers my template, whose fault is this?
  54. Inserting HTML to close and open divs in WP_Query loops
  55. Change query from cat id to slug or name?
  56. Query only the posts with a post format of “audio”
  57. Display Current Post’s Position in Custom Taxonomy
  58. Using Wp_Query without the loop?
  59. WP Query with multiple tags by get the tags
  60. Custom WP_Query id
  61. Woocommerce pagination and result count after custom loop
  62. Orderby custom meta returns random order
  63. Include latest author posts with pagination in single template?
  64. How to querry for an item that saved in an array?
  65. get_post() is not returning correct value
  66. Intiger meta value with ‘>=’ returns posts with lower value
  67. Update query for wp_posts and wp_postmeta
  68. How to print term name inside wp post loop
  69. CPT category post/content is not showing on my page, Please review my coede
  70. WP_Query with page_ids in arguments without a result
  71. Query not sorting DESC
  72. Prioritising and Ordering Posts By Category Name Using A Custom Loop
  73. Filter products on category AND tag
  74. meta_query – check for multiple meta values in key which holds an array of values
  75. How to sort wordpress posts already selected by WP_QUERY
  76. Searching for a specific month in a metadata saved as Timestamp (Wp_Query)
  77. SEARCH QUERY PLEASE HELP | call_user_func_array() expects parameter 1 to be a valid callback php
  78. WP_Query on custom key and value
  79. Set “editor” role to existing user
  80. how to get wp_query posts only first letter of alphabet A?
  81. How to mix two orderby-parameters into one ordered result
  82. Custom Post Type WP_Query with filters and search
  83. Merge wp-query and get_users
  84. Query by meta value (add a dropdown of all values)
  85. wp_query beginner
  86. WP Query issue for multiple values
  87. Calling a function with WP_Query only ever brings the first result
  88. get last child post by wp_query
  89. WP_Query don’t working with fixed post_id and term_taxonomy
  90. How can I use WP_Query argument ‘Like %..%’?
  91. How To Query All Attachment Images Found In Post Galleries
  92. WordPress meta_query not working
  93. Create multiple sections for all categories and then queries all the posts for each of those categories
  94. $wp_query when new WP_Query
  95. Query to get all the posts of more than 2 meta_value having same meta_key?
  96. Unable to pass variable
  97. WP Query get posts by specific author IDs if one of several logged in authors
  98. Edit WordPress loop, taxonomies, & filter
  99. How to display posts from a specific term first then another posts from another terms using tax_query
  100. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles