wpdb->prepare and mysql UPDATE – how is it done?

I sort of fixed your query. It needs a table and a WHERE condition to prevent changing all rows. Even a LIMIT 1 at the end won’t hurt.

$rows_affected = $wpdb->query(
    $wpdb->prepare(
        "UPDATE {$table} SET removed = %s, post_id = %d, user_id = %d, status = %d;",
        $cur_date = date('Y-m-d H:i:s'), $postid, $userid, 0
    ) // $wpdb->prepare
); // $wpdb->query

Just add the WHERE… in the MySQL query. Proper use of prepare is:

$wpdb->prepare($format, $arg1, $arg2, ...); // just like printf()

Related Posts:

  1. Is it mandatory to use $wpdb->prefix in custom tables
  2. WordPress and multithreading
  3. Actions or filters fired when data is saved in a custom table
  4. Custom Plugin Database relations
  5. Activation hook not creating table
  6. How to create database table, add data, update and delete using wpdb via plugins?
  7. Using WPDB to output raw XML fails because of wp-blog-header.php
  8. $wpdb->update Issue
  9. WordPress database error: [Query was empty] – using $wpdb->prepare()
  10. How to get inserted row IDs for bulk/batch insert with wpdb query?
  11. Update database record in plugin
  12. WordPress plugin tables become corrupt
  13. multiple record insert creating many duplicate records
  14. Should I use wpdb prepare?
  15. Default table collation on plugin activation?
  16. Getting wrong relationship value in $args in wp_Query?
  17. Not sure the best way to save custom plugin data
  18. The ideal place for storing persistent PHP objects
  19. What is the added “complexity” of custom tables?
  20. Plugin development with unit tests
  21. How is the data stored in the database?
  22. Formatting of curly brackets array from WP database to get more readable output
  23. How to modify post content before writing to database?
  24. $wpdb->insert is changing a value
  25. Retrieving custom fields with $wpdb->get_results
  26. Hello dolly type plugin that allows people to add their own
  27. How to use mysql IN statement with wpdb update method?
  28. Database for development
  29. Is the usage of ON DELETE CASCADE wrong or not allowed on wordpress?
  30. Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
  31. What for the tables ending with the meta used in database of wordpress?
  32. Creating table with plugin is not working
  33. How to Download and install plugin database remotely
  34. Get a custom table to an array
  35. Update/insert only a column of database table
  36. How to Create database table when Plugin installed/activated, and delete database when Plugin deleted
  37. How to insert data to a database table when the field is not yet created?
  38. Where to store the name of a custom table?
  39. Subscribe to author?
  40. include wp-blog-header not working on MAMP
  41. I’m designing a plugin to create database indexes. Suggestions?
  42. creating custom function to log actions in plugin
  43. WordPress database error for query INSERT INTO
  44. How to connect to AWS RDS external database (not for the core WordPress db)
  45. Issue regarding $wpdb->prepare()
  46. How should I store a log for my plugin
  47. Error on inserting a form value to database
  48. Are there any scripts, classes, and/or functions built-in to WP for a plugin to export/import its saved data from wp_options?
  49. Strange issue saving custom field data for a WooCommerce order
  50. how to search users by ajax live search
  51. How to perform a heavy and long process in cron jobs?
  52. Form doesnt save to database
  53. Adding custom end points, No error line
  54. Updating Woocommerce Settings API when WordPress Settings API saved and vise versa
  55. Update results, Before deleting the related category [closed]
  56. Is using custom table to suit business needs instead of transients a big hit to page load speed?
  57. Optimising a big WordPress site
  58. What is the best way to store a few fields?
  59. How to query custom db table?
  60. Delete data from database using row action
  61. How do I have now a duplicated user entry if this is not allowed (and I cannot replicate it)?
  62. Issue running db create table query from static method
  63. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  64. Make Database query only when option is updated
  65. Can we intercept user_login and user_pass from a wp_login_form?
  66. Two different wordpress sites – same server and IP address. Gaining Access to database 1 of 2
  67. Plugin Development: Storing and Manipulating Data That Fits JSON in Database
  68. What might be the reason of Couldn’t fetch mysqli_result on another domain?
  69. How to avoid conflicts with db.php / $wpdb and other plugins that decide to use them?
  70. How do I debug an error that a plugin is causing?
  71. $wpdb in php 5.5
  72. Update plugin settings option_name for big plugin update
  73. select a single val though a table in wordpress
  74. Plugin to create Posts and Forums then choose category and parent forum
  75. dbdelta failing with error: “WordPress database error Table ‘wp_2_myPlugin’ already exists
  76. Why doesn’t my Table get created?
  77. How to display specific data from a custom table to logged in users with a custom role
  78. $wpbd->insert_id is returning null
  79. Error code when migrate
  80. How to securely controlling data without keeping it in postmeta?
  81. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  82. WordPress Query doesn’t return the correct value
  83. WordPress Fatal error: Uncaught Error: Call to undefined function dbDelta()
  84. Use admin-post to submit form data to external database
  85. bindParam? WordPress 4.9.5 SQL LIKE statement %s and %LIKE%
  86. Save in my custom admin page and redirect to the saved object
  87. Relational / Associate tables using native WordPress functionality
  88. How to store in the database directly the translation?
  89. How and when would I implement some code which would take data from one part of the Db and put it in another?
  90. pull data from wordpress database
  91. How to implement pagination into a wpdb->result query?
  92. Ajax not working to insert, query and result data
  93. Associating special meaning with user id 0
  94. What method should I use to store my plugin data (multi level menus with options on each item)
  95. How to add additional field in a table row after creating a table?
  96. Post data in wp-admin to external database
  97. Nothing happens on WordPress Update command
  98. Fixing plugin for wpdb::prepare
  99. Leveraging Core Functionality in Icon Upload Plugin [closed]
  100. WordPress database error: [Table ‘bitnami_wordpress.questions’ doesn’t exist]