wordpress prepare error

Use double percent sign like so: %%special-purpose%%.

Or you could also use a placeholder, i.e. LIKE %s and then set the 6th parameter for $wpdb->prepare() to %special-purpose%, i.e.

$wpdb->prepare( "your SQL query", $earth_radius, $lat, $lng, $lat, '%special-purpose%' )

Related Posts:

  1. Return $post_id when DOING_AUTOSAVE?
  2. Including Angle Brackets In Pre Sections
  3. Anchor Text code string is automatically modified by WordPress
  4. WordPress is converting & to & inbetween [code] brackets
  5. Notice: Undefined property: wpdb::$current_post What can be wrong?
  6. Where to save common libraries?
  7. source code: WP_INSTALLING vs. WP_SETUP_CONFIG in setup-config.php
  8. Sublime Video: Playlist which gets all attached videos
  9. Code Friendly Block Quotes
  10. Remove line breaks from ?
  11. How to fix a “globals” issue to avoid a rejected theme?
  12. Need resource on available functions and objects
  13. WordPress wp_insert_post() returns 0 but not not wp_error
  14. I want to remove the home page header image from all other pages
  15. Proper implementation/use of code/syntax highlighting
  16. How to remove all comments from JS, HTML, CSS files?
  17. What data validation we must use in different contexts?
  18. Need To Post Unformated Code
  19. Sidebar login: How do I get the username to show after “Welcome”?
  20. How to manage multiple wordpress project with shared code base
  21. Block IP Addresses using Code [closed]
  22. Find Total Authors
  23. Why does HTML entities are still encoded in Code Block?
  24. How to create a checkbox to show/hide a field in WooCommerce checkout [closed]
  25. how to display google maps with javascript
  26. How to pass https://achecker.ca/ validator? [closed]
  27. How to write custom code on WordPress?
  28. Remove Metaboxes
  29. Google analytics won’t work in wordpress
  30. Where do I add an action hook & callback in my theme?
  31. How do I reset my footer.php to its original state? (theme: Origami)
  32. Commenting out in HTML editor breaks template
  33. Adding code to send referrer on login page
  34. Table styles disappear when updating content
  35. Manage recurring event time
  36. wp_editor save all content
  37. Need an elegant solution to declare the value of two variables based on the count of the post
  38. How to insert integration code for CRM?
  39. A good way to include snippets of code in both posts, pages and Event Manager Template files?
  40. Anchor Text code string is automatically modified by WordPress
  41. Return $post_id when DOING_AUTOSAVE?
  42. Changes in code only show after changing theme
  43. Code Highlighting in BlockQuote
  44. feed url problem
  45. Where do I go to add a tag before the closing body tag?
  46. Best collection of code for your .htaccess file [closed]
  47. How to get a variable number of posts per post type on the main loop?
  48. Create custom [sourcecode] shortcode, the right way?
  49. how to group custom post types
  50. How do i structure my theme folder to avoid one huge list of files
  51. Editing Source Code in WordPress
  52. API integration with WordPress
  53. write in functions.php
  54. Pinterest Integration Using functions.php
  55. Successful or Error Message after running mysql code in functions.php
  56. Beautify WordPress HTML output without any plugins
  57. Date/time limitation of posts where function must be executed
  58. How to implement Google reCaptcha without installing a plugin?
  59. Connect Second Database to WordPress
  60. If in category to be inside of a function
  61. Hide wordpress field if data is empty in post!
  62. code suddenly appearing from my tempate second loop
  63. Latest post in a specific menu
  64. How to add an automatic refresh in WordPress for a Page/Post or an embedded OneDrive/Excel HTML Code?
  65. WordPress change Language not working
  66. What is this code in my theme’s footer.php causing chmod permission warnings? [closed]
  67. How can this crude function be improved?
  68. How to run a function in every page, every device
  69. Can I do in-page changes binding events/triggers to actions in WordPress?
  70. Make order notes field at woocommerce checkout only viewable on front end by Admin level user role [closed]
  71. Fatal error: Uncaught Error: Call to undefined function get_header() [closed]
  72. Search Count WordPress Theme
  73. WP List Pages – Add Title Attributes to Anchors
  74. Line breaks changing to when switching between HTML and Visual tab!
  75. Allow tags between shortcode in comments
  76. Counting number of posts in multiple (sub)categories using shortcode
  77. Need help for some PHP code
  78. Save Meta when custom Taxonomy Saves
  79. using add_filter in a template_redirect function?
  80. restrain filter on get_the_excerpt to queried item in stead of current post
  81. WP search box on page not finding .PDF files
  82. WordPress Sticky Post Count “Fix” Breaking Pagecount by 72 pages!
  83. How can I use javascript in specific posts without relying on a plugin?
  84. How to add specific posts to specific pages in WordPress?
  85. Code for cron to delete posts that contain specific expression (e.g. “unable to fetch” every 30 minutes
  86. Website Tablet Check Out Field Issue
  87. style.min.css code issue
  88. how to run a php code in widget?
  89. Pull ‘Popular Posts’ within specific timeframe
  90. widget that will do shortcodes that user inputs
  91. How to add a class name to the ancestor of a post?
  92. Themes with variable width or single columns? I want to display source code
  93. Creating a press page for our project
  94. Website Developer has gone missing! How to gain full access of your code from a WordPress website?
  95. How do I upload my WordPress code files from previous website onto local host WordPress website?
  96. Text before price on WooCom
  97. What’s wrong in the WordPress Meta Box Generator code?
  98. May I know where to edit the tax rate?
  99. How to add links to different language versions of WordPress
  100. how to create twitter card without plugin in wordpress website?
techhipbettruvabetnorabahisbahis forumueduedusedueduseduseduseduseduseduedu