$wpdb->delete column values IN ARRAY()?

No, wpdb::delete does not handle anything other than WHERE field = X. You can just use the query method instead:

$ids = implode( ',', array_map( 'absint', $ids ) );
$wpdb->query( "DELETE FROM table_name WHERE ID IN($ids)" );

Related Posts:

  1. How to return number of found rows from SELECT query
  2. Update results, Before deleting the related category [closed]
  3. I can’t update my data through $wpdb
  4. Add row to custom database Table and delete all rows older than 1 day
  5. select a single val though a table in wordpress
  6. Using wpdb to connect to a different database is not working
  7. MySQL database migration to WordPress
  8. Putting form result in my database
  9. Can i use php sql functions instead of $wpdb?
  10. Check if post of title already exists
  11. Does WordPress cache get_user_meta() results?
  12. How to Join two tables from separate databases within WordPress
  13. error importing localhost export file to server
  14. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  15. How to sort results from a custom database table
  16. How can I call a row of user specific data from a custom table added to the WP Database
  17. How to merge local and live databases?
  18. Import 10,000 Users into WordPress WITH a specific ID for each user
  19. WPDB: how to get the value of a field in a custom database table
  20. WP database error for comments_popup_link()
  21. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  22. No wp-config.php file on local install of wordpress – site still displays
  23. WordPress get pagination on wpdb get_results
  24. Different database query in function.php using mysqli
  25. Converting MYSQL to WordPress $WPDB
  26. Why is variable not working on custom sql query using wpdb?
  27. Show MySQL errors that occur when I excute $wpdb->insert()
  28. Any possible way to make $wpdb->get_results() return anything else than array?
  29. database interactions using OOP
  30. Can’t get wp_insert_post to work
  31. Trying to establish connection to External Database
  32. Create WP_Query to search for posts by their categories or their parent/child categories
  33. WSoD being caused by this piece of code
  34. WordPress not reflecting changed of the database
  35. $wpdb->update with multiple parameters gives error
  36. How can I save unique user data on my site? [closed]
  37. How WordPress reacts to a lack of memory of the server [closed]
  38. wp query foreach deleting record returning only first or last item
  39. database sent to a JSON file
  40. inserting a post from an extern php file but post content doesn’t show on wp site
  41. Database query works fine outside WordPress
  42. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  43. $wpdb->insert() does not Insert record in a table
  44. Using custom tables for old posts
  45. Help with a $wpdb MySQL Query
  46. How to retrieve the data from the sever and displaying it in a page?
  47. $wpdb returns duplicate posts
  48. Mixing variables into an array when inserting values
  49. wpdb prepare insert table doesn’t work
  50. Should I use WordPress to skin a database website?
  51. Creating Database Table vs. Adding MetaData to Post & User
  52. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  53. Most commented posts by time period (last 12h, last 24h and etc)
  54. How can I add a new row in a separate database when someone registers via WordPress?
  55. Basic wpdb update question
  56. wpdb Cannot Update column in Database
  57. Output: “Array”
  58. How to use mysql LIKE with wpdb?
  59. Delete database record using plugin from admin panel
  60. Wpdb get->results to out the the month from the db
  61. How do I prepare strings for insertions as values into a MySQL table?
  62. How to use AJAX in WordPress in MYSQL query?
  63. WPDB – Read and write value from / to database
  64. form $_post action value gets truncated after it passes through two forms
  65. WPDB secure custom form
  66. Adding data to custom wordpress database table
  67. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  68. populate select options from extra mysql table data
  69. Query the links Database
  70. SQL error with custom query
  71. MySQL Query Returns Array () In Shortcode
  72. Add posts to custom table in database instead of wp_posts
  73. Passing in MySQL prepare statement parameter separately throwing error
  74. Convert a column of a table containing an Array as response in HTML
  75. Database SQL query error
  76. Please help! I have a problem with getting wordpress databas
  77. Error establishing a database connection (Set-up locally)
  78. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  79. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  80. Conditional formatting on data fetched from MYSQL
  81. What is the correct way to search 3 custom fields only in WordPress?
  82. How to grab data from input and store it into custom table in database?
  83. Advanced WordPress SQL Query
  84. can’t delete a row from post_meta table
  85. MySQL query in WordPress with AJAX
  86. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  87. How to set max users to 17.000
  88. Passed variable gets undefined variable error on insert on next page
  89. MySQL queries in WordPress
  90. How to fetch results from database
  91. How to connect database table to each registered wordpress user.
  92. Using the same shortcode to show any table from the database
  93. Querying multiple meta_keys in WordPress SQL query
  94. Let users register weight each day and save it in DB
  95. Fetching wpdb data from a php file seems to break?
  96. How to pass username into form that sends data to database
  97. Insert into db with foreach problem
  98. Execute multiple PHP Snippets causes error?
  99. Error resetting database index using ALTER TABLE in $wpdb->query
  100. Can’t insert into a database wordpress

Leave a Comment