How to prepare an array of values with $wpdb

Not quite there. In your first example you have sku LIKE %s and in your example you have product_sku LIKE '%{$matchedProduct->sku}%'. That’s not the same.

$wpdb->prepare() uses sprintf replacements. That’s where you get the %s in your first query. If you look at the sprintf documentation under specifiers, you’ll find a list of replacement patterns. $wpdb->prepare() uses the same specifiers, for example %s for a string, %d for an integer, etc.

In your case, you probably want to use product_sku LIKE %%%s%%.

Why did you add extra % signs?

With printf() and sprintf() functions, escape character is not backslash \ but rather %.

That means %% is output as % and %s is output as 42ts (for example). Altogether the output looks like product_sku LIKE %42ts%.

Related Posts:

  1. Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
  2. How do I check for a duplicate record before inserting using wpdb
  3. $wpdb->insert not working in any way
  4. get_results on large datasets
  5. wpdb->insert not working
  6. passing variables as parameters to stored procedures via wpdb from php-script
  7. How do I create a single.php for a specific category?
  8. $wpdb->query() multiple query support
  9. Using $wpdb generates DB error
  10. How do you use prepare when asking for a list of id’s
  11. Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
  12. how to execute different sql query in non-sanitized $wpdb->get_results function
  13. $wpdb not returning data
  14. How to get top 10 user is based on user meta value
  15. $wpdb Query Result not coming but in phpmyadmin it works [closed]
  16. $wpdb insert array
  17. How to update records using $wpdb?
  18. Join inside a wpdb query.. confused!
  19. Why doesn’t my insert query work?
  20. How to prevent $wpdb->prepare stripping a leading zero in variable value?
  21. Generate a unique hash/number for tracking on $wpdb insert
  22. show badge with count for pending items in custom post type
  23. wpdb->insert and stripslashes against sql injection
  24. create drop down menu in theme customizer from custom db
  25. Are there risks associated with using wp_options table using wpdb to update theme options
  26. $wpdb->insert is running multiple times on page load, but only called once
  27. $wpdb select query by month, post type, and taxonomy term
  28. Get an array of meta_values for a user meta_key
  29. WPDB – How to search a column in a table
  30. Confused by $wpdb->prepare
  31. wp_create_user not properly entering password
  32. WordPress (on AWS ubuntu) database Fails “Connection refused in .. /wp-includes/wp-db.php on line 1531”
  33. How to display user_nicename and usermeta values by custom query in WordPress?
  34. How can I combine one field using wpdb and group by?
  35. How to get entry by title by using wpdb
  36. how to use $wpdb->prepare to update a custom table
  37. $wpdb not being defined in function: Fatal error: Call to a member function query() on a non-object
  38. How to obtain a reference to $table_prefix in $wpdb object
  39. Trying to Connect to different database
  40. WordPress is trimming leading 0s
  41. how to assign content to a different author while loading content
  42. Why does this WPDB code throw an empty WPDB error? [closed]
  43. wordpress $wpdb works only once
  44. get_results not returning anything
  45. WordPress core code contains things marked as deprecated by… WordPress?
  46. $wpdb – joining shows no result
  47. Compare transient data with a meta box value
  48. How to left join meta in queries [closed]
  49. Register custom table for WP to use in a plugin
  50. wpdb->get_row is selecting the variable as a column name
  51. CREATE TABLE with dbDelta does not create table
  52. Save data from a checkbox to a wpdb array
  53. Display category names on edit user profile using $wpdb
  54. Get unique results from this function
  55. Can’t call WPDB inside RSS template
  56. wpdb and acf via wp rest api
  57. WPDB SQL Ignore `post_status` Parameter
  58. WPDB Table Does Not Exist
  59. Inserting a MySQL record into a table with an array of field names and an array of values
  60. Incorrect Use of wpdb::prepare()
  61. wpquery properties last_query and last_result : should these be public or private?
  62. Ascending order of yearly archives [closed]
  63. check that the data exists before sending it to wpdb
  64. $wpdb->get_results(…) with $wpdb->prepare(…) returns empty array despite correct query
  65. wpdb insert formatting for date in array
  66. wpdb->insert with special chars failing with collation utf8mb4_unicode_520_ci
  67. no result returns when using $wpdb->get_results with where clause
  68. Access to numerically indexed array in wpdb Class and undefined offset
  69. update not working using wpdb
  70. get_posts() SQL Injection
  71. $wpbd->insert() does not insert user data
  72. Why $wpdb->insert and $wpdb->update not working server but it is working in localhost?
  73. wpdb prepare placeholders for MySQL keywords
  74. Sql query triggered twice
  75. $wpdb select returns empty array
  76. Unable to insert data into using custom plugin
  77. Debugging db calls: $wpdb->insert works on test site, not on identical production site
  78. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  79. Creating an Angular factory from custom database table
  80. wpdb get_row database query inquiry
  81. Depreciated Call -> Function wpdb::escape()
  82. How do I update post based on meta_key in another table?
  83. Object Cache – Avoid db queries totally
  84. Inserting and updating rows with wpdb indreases integer fields by 1 point sometimes
  85. Creates only one table and not the other
  86. Retrieve a list of users based on some conditions
  87. adding a log row log table, when the draft post publish
  88. wp_commentdata: error in documentation?
  89. looking for a way to allow users to backup the plugin db data(save as)
  90. wp-postratings: list current user’s unrated posts
  91. esc_sql inserting weird chars to DB
  92. Error inserting row into table
  93. Retriving array size from serialized data
  94. Out of Memory – Line 791 of WP-DB.php (mysql_real_escape_string)
  95. get only 1 wpdb and get taxonomy, post to next page [closed]
  96. Site going down due to slow queries
  97. Call to a member function get_results() on a non-object in wordpress plugin
  98. WP Recommended Table Exclusions?
  99. query_vars doesn’t return query string (trying to get data from $wpdb)
  100. $wpdb->prepare UPDATE process not work in functions.php