How to use mysql LIKE with wpdb?

According to the Codex, the delete method will not accept the LIKE operator. You’ll be better off just using the query method.

$query = $wpdb->prepare("DELETE FROM $wpdb->posts WHERE post_type="flamingo_inbound" AND post_content LIKE %s", '%'.$mail.'%');

$wpdb->query($query);

Hopefully $mail doesn’t have a % or _ character otherwise you need to escape it before you build $querylike so:

$mail = $wpdb->esc_like($mail);

Related Posts:

  1. Can’t get wp_insert_post to work
  2. WSoD being caused by this piece of code
  3. $wpdb returns duplicate posts
  4. form $_post action value gets truncated after it passes through two forms
  5. Passed variable gets undefined variable error on insert on next page
  6. How to return number of found rows from SELECT query
  7. $wpdb->delete column values IN ARRAY()?
  8. Custom query to get post names beginning with a digit
  9. Custom SQL query to get List of posts with featured image url
  10. Delete post revisions on post publish
  11. Disable External Pingacks on WordPress Posts and Only Allow ‘Self Pings’
  12. Is the regular ajax request method safe or I should use admin-ajax.php?
  13. Successful or Error Message after running mysql code in functions.php
  14. New Plugin Review
  15. Use template for posts with a particular category grandparent
  16. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  17. Insert all post IDs in new database table
  18. Styling images coming from another blog
  19. WordPress get pagination on wpdb get_results
  20. Ajax $wpdb not returning table data
  21. Converting MYSQL to WordPress $WPDB
  22. PHP code inside shortcodes
  23. Why is variable not working on custom sql query using wpdb?
  24. Show MySQL errors that occur when I excute $wpdb->insert()
  25. Query all posts of a custom taxonomy term
  26. Display fields as values in array from external SQL DB
  27. Trying to establish connection to External Database
  28. How to insert a single row to WP database table?
  29. Get post id in a function when edit/add a post
  30. How to check if a meta value has already been assigned to any user?
  31. wp_trim_words() does not work with my code Am I doing any mistake in my code?
  32. Update results, Before deleting the related category [closed]
  33. wp query foreach deleting record returning only first or last item
  34. Database query works fine outside WordPress
  35. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  36. $wpdb->wp_users returning empty value for
  37. $wpdb->insert() does not Insert record in a table
  38. Help with a $wpdb MySQL Query
  39. Which PHP page is the Default Posts Page
  40. Custom array from a query only write the last row of the query
  41. Function works everywhere, how to keep it to execute when creating a new post
  42. Pagination on Custom Post
  43. Mixing variables into an array when inserting values
  44. Use $wpdb or other PHP script method to find/replace in WP database
  45. How can I add a new row in a separate database when someone registers via WordPress?
  46. Basic wpdb update question
  47. I can’t update my data through $wpdb
  48. Output: “Array”
  49. Reading settings in the home page precisely home.php
  50. get post id from wp_insert_post for get_template_part
  51. How do I prepare strings for insertions as values into a MySQL table?
  52. How to use AJAX in WordPress in MYSQL query?
  53. Change MySQL PDO connection to a WPDB connection
  54. Why won’t this wpdb get_results query return results?
  55. Why when I create a new post I found 2 record related to this post into the posts database table?
  56. Add row to custom database Table and delete all rows older than 1 day
  57. select a single val though a table in wordpress
  58. making php value numeric
  59. populate select options from extra mysql table data
  60. MySQL Query Returns Array () In Shortcode
  61. remove specificly the last tag in all posts
  62. Modify WooCommerce used to get all orders in dashboard
  63. Add posts to custom table in database instead of wp_posts
  64. Passing in MySQL prepare statement parameter separately throwing error
  65. Convert a column of a table containing an Array as response in HTML
  66. Database SQL query error
  67. How to Send Pingbacks for all Posts in WordPress?
  68. posts_per_page displays only 2 posts instead of 4 posts
  69. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  70. Conditional formatting on data fetched from MYSQL
  71. Using wpdb to connect to a different database is not working
  72. Send POST request to Flask app from functions.php file
  73. Change upload URL by mime type
  74. Modify post image in full size
  75. WordPress post insertion from PHP file
  76. Getting page / post URL on publish and / or update
  77. Displaying POST content with HTML tags and all
  78. Rewrite SQL query as a prepared statement and use in foreach loop
  79. Advanced WordPress SQL Query
  80. Using Tag Groups: Displaying groups and adjacent tags of current post
  81. How can I display a query in a page?
  82. MySQL query in WordPress with AJAX
  83. insert thumbnail image from php script
  84. Can’t put a hyperlink on Featured Post’s Image
  85. How to set up an auto delete post?
  86. Weird Behaviour: Not all WordPress Posts appearing
  87. Published custom posts missing
  88. WordPress get_post_meta issue
  89. Insert wordpress tags below posts via functions.php
  90. Using the same shortcode to show any table from the database
  91. Trying to see if page is category or single and displaying title with appropriate heading tag
  92. MySQL database migration to WordPress
  93. How to modify this function to exclude also the post belonging to a specific category?
  94. How to display the date under the post title?
  95. Add multiple HTML attributes to an Elementor button
  96. WooCommerce: write featured image dimensions to custom fields in product’
  97. How do I get a function to work in single.php
  98. transition_post_status hook, works – but not if the post is new
  99. Putting form result in my database
  100. How can I update a value of a field depending on outside source?