wpdb_prepare with multiple or condition

I think your first partial code be this partial code:

$wpdb->prepare( "SELECT * ... from ... WHERE ( post_title LIKE '%%%s%%' or post_content LIKE '%%%s%%' )..., $string, $string );

You have to have to pass the same number of arguments into the query as you specify (with %s) in it.

Related Posts:

  1. Inserting Post Meta From SQL
  2. How to execute mulitple statement SQL queries using $wpdb->query?
  3. Create table from array with prepare
  4. Using wpdb to connect to a separate database
  5. WPDB Insert or if exists Update
  6. How to fetch Data in WordPress using MySQLi or $wpdb
  7. wpdb->insert multiple record at once
  8. How to define composite keys with dbDelta()
  9. Display data from a non wordpress database on a page template
  10. Why does dbDelta() not catch MysqlErrors?
  11. What causes the “max_user_connections” warning on WordPress frontend?
  12. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  13. Database slowdown after update to 3.4.1
  14. Query WordPress database by registered date and role
  15. Size article thumbnails and retrieve them directly from database
  16. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  17. SQL Error wp_commentmeta – incorrect table definition
  18. WordPress database error – Error in SQL syntax – I can’t identify any error?
  19. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  20. How do I get the posts within a certain year/date(with sql query)?
  21. Advanced SELECT query with condtional statements
  22. Redirecting to old domain after migration website
  23. WordPress running SQL query to update database from form
  24. WPDB SQL query with prepare() returning variable, not db value
  25. Have working sql query… trying to adjust it to use $wpdb
  26. Custom WordPress Table wpdb
  27. Why this query is not showing any result on wordpresss home page?
  28. Best practice to limit results in get_row()?
  29. Clear Terms from Taxonomy for Specific Post IDs?
  30. Why does changing Database Table Prefixes result in loss of content?
  31. Trouble running $wpdb->query() with last_insert_id
  32. SQL query to set posts in bulk based on the post content
  33. Query Column of Specific ID from Database Table
  34. How to delete a particular row in a database table
  35. How to create more than one new wpdb object?
  36. How to connect and insert data in database of wordpress?
  37. $wpdb->get_var – What value is returned when zero records are found?
  38. Getting value from database table depending on field value
  39. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  40. DB prefix not updating
  41. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  42. “BS_” rows in postmeta table
  43. Where is the HTML-handler part in the wpdb class?
  44. Help posting values to DB on submit using $wpdb->query
  45. WordPress Database Query works in phpMyAdmin but not in the code
  46. How to create index (sql) to a meta_key?
  47. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  48. Delete all users meta that named: user_avatar
  49. insert data from a form:: Warning Empty query mysqli::query()
  50. How can I get $wpdb to show MySQL warnings?
  51. Correct and secure way to access a custom SQL database in a custom PHP template file
  52. How to get specific table by current user login
  53. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  54. How To connect to the same WordPress database with different database user
  55. using same mysql user with many databases
  56. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  57. export individual posts to text files or a single csv file
  58. SQL query : Select a thumbnail for a media
  59. why you don’t Implement PDO for access every thing to database
  60. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  61. Uploading to WordPress Database
  62. Deleting WordPress posts and media files based on author via MYSQL database
  63. SQL errors when querying for something with apostrophes
  64. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  65. Rename a table in MySQL
  66. How should I tackle –secure-file-priv in MySQL?
  67. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  68. Error Code: 2013. Lost connection to MySQL server during query
  69. Checking if Database Table exists
  70. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  71. Is it possible to define two databases for one installation?
  72. Hook into $wpdb
  73. wpdb->prepare function remove single quote for %s in SQL statment
  74. “MySQL server has gone away” since update to 3.8
  75. Can I transfer a mysql database to another site?
  76. MySQL Syntax Error upon restoring database from backup [closed]
  77. How to use a different database to list and manage comments in the backend
  78. wpdb custom post_type problem
  79. In what part of the WordPress core does the users table and usermeta table get joined?
  80. Migrating from PDO using SQLite to clean new install using MySQL
  81. $wpdb->insert Giving duplicates
  82. Duplicated site isn’t recognized as a site
  83. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  84. Changing root password in PHPMyAdmin for WordPress Database when going live
  85. How to properly check if a table exists in WordPress Database using Show Tables Query
  86. Use $wpdb or other PHP script method to find/replace in WP database
  87. Is my way to change WordPress server is correct?
  88. Replacing javascript link in WordPress database without getting mysql syntax errors
  89. how to access 2nd Mysqli Database from different server for wordpress
  90. Error establishing a database connection – WordPress setup, everything else is working
  91. How to map data on CSV to web pages?
  92. How to add download link from database on custom page template?
  93. Search and Replace in Windows XAMPP site
  94. The function is deprecated; use mysql_real_escape_string() instead
  95. How can i syn wordpress user table with a stand-alone php script?
  96. WPDB delivers wrong results from complex queries
  97. WordPress Database Posts Table query
  98. Mysql Queries per Visit – Crazy High
  99. Why are my WordPress post queries so slow?
  100. Custom wordpress SQL statement for a website