How to delete field using WPDB?

You can’t “delete” a field in MySQL, this only works for complete rows.

However, you can unset values, meaning setting them to their original state, usually NULL or an empty string.

$wpdb->update($wpdb->posts, array(
    'product_rank' => NULL
), array(
    'ID' => $post_id
));

Related Posts:

  1. Using wpdb to connect to a separate database
  2. WPDB Insert or if exists Update
  3. get_results using wpdb
  4. $wpdb won’t insert NULL into table column
  5. Get error messages when $wpdb->insert() returns false?
  6. Does dbDelta delete columns as well?
  7. How to fetch Data in WordPress using MySQLi or $wpdb
  8. wpdb->insert multiple record at once
  9. WordPress Unit Testing – Cannot Create Tables
  10. How to define composite keys with dbDelta()
  11. Does wpdb add considerable overhead on queries with large result sets?
  12. Why does $wpdb return strings for mysql integer values?
  13. $wpdb->prepare() warning in WordPress 3.5
  14. Inserting data into custom tables
  15. Hook into $wpdb
  16. Display data from a non wordpress database on a page template
  17. How does $wpdb handle COUNT(*)
  18. WordPress database error: [Query was empty] [closed]
  19. Why does dbDelta() not catch MysqlErrors?
  20. Connecting to external oracle database
  21. Can’t save ajax value to database
  22. What causes the “max_user_connections” warning on WordPress frontend?
  23. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  24. Updating all rows of table with $wpdb
  25. How to execute mulitple statement SQL queries using $wpdb->query?
  26. Is $wpdb->prepare escaping to much? How to use it properly?
  27. When and why should I use $wpdb different return types?
  28. How wordpress accesses its own database
  29. Remove database entries where post_date > expiration date
  30. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  31. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  32. How to use a different database to list and manage comments in the backend
  33. WP Database Table to CSV file
  34. Cannot update custom database table row
  35. wpdb_prepare with multiple or condition
  36. Show last modified date of database
  37. $wpdb->insert is not working
  38. Extracting the post_id via the wp_insert_post action (external db query)
  39. WordPress database error – Error in SQL syntax – I can’t identify any error?
  40. In what part of the WordPress core does the users table and usermeta table get joined?
  41. Multiple wp_options tables to share content across installs
  42. Advanced SELECT query with condtional statements
  43. Select two sums with single get_var statement
  44. WordPress choose wrong database
  45. Redirecting to old domain after migration website
  46. Create table from array with prepare
  47. Update from 4.5 to 4.6 failing
  48. Does WordPress $wpdb functions wait when table is locked?
  49. $wpdb->insert Giving duplicates
  50. I’m not able to get access to $wpdb [duplicate]
  51. Have working sql query… trying to adjust it to use $wpdb
  52. Problem in using wpdb
  53. $wpdb->query can’t insert data
  54. Custom WordPress Table wpdb
  55. How to fetch records from database WordPress
  56. Best practice to import user base (subscribers) from one website to another?
  57. AJAX wp-mysql running too slow
  58. CreateOrUpdate in WordPress
  59. Problem migrating to localhost
  60. Clear Terms from Taxonomy for Specific Post IDs?
  61. How to get a list of WordPress default database tables?
  62. Connecting to a different database
  63. Query Column of Specific ID from Database Table
  64. How to delete a particular row in a database table
  65. How to create more than one new wpdb object?
  66. Update multiple rows in one query
  67. How to connect and insert data in database of wordpress?
  68. Should I use an additional column in the DB?
  69. access JSON results from wordpress database with wpdb
  70. Getting value from database table depending on field value
  71. Creating and Using Tables in the WordPress Database
  72. wpdb->insert not inserting first variable
  73. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  74. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  75. wpdb Insert unknown post data dynamic foreach loop
  76. How do I get database rows from a custom table using wpdb?
  77. How to insert a value to decimal type field using wpdb->prepare?
  78. How to rerieve comments and their replies from DB
  79. Where is the HTML-handler part in the wpdb class?
  80. Help posting values to DB on submit using $wpdb->query
  81. How to add download link from database on custom page template?
  82. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  83. insert data from a form:: Warning Empty query mysqli::query()
  84. How can I get $wpdb to show MySQL warnings?
  85. About wp database hooks (error establishing connection)
  86. How to get specific table by current user login
  87. How To connect to the same WordPress database with different database user
  88. Accessing content from third party as native posts in WordPress
  89. Should I Use only wpdb Class to Write Custom Queries?
  90. Call to a member function insert()
  91. I have include wp-config, should I add global $wpdb also?
  92. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  93. using same mysql user with many databases
  94. How can I retrieve data from alternate database using wpdb class?
  95. Pulling values from a sepcific row in table
  96. Creating Tables in WordPress Database
  97. Inserting into data into external DB using WPDB
  98. Insert Extra fields added in the front end registration form to DB
  99. $wpdb->insert not working for last select option
  100. $wpdb->prepare returns empty array
error code: 523