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:
- Return $post_id when DOING_AUTOSAVE?
- Including Angle Brackets In Pre Sections
- Anchor Text code string is automatically modified by WordPress
- WordPress is converting & to & inbetween [code] brackets
- Notice: Undefined property: wpdb::$current_post What can be wrong?
- Where to save common libraries?
- source code: WP_INSTALLING vs. WP_SETUP_CONFIG in setup-config.php
- Sublime Video: Playlist which gets all attached videos
- Code Friendly Block Quotes
- Remove line breaks from ?
- How to fix a “globals” issue to avoid a rejected theme?
- Need resource on available functions and objects
- WordPress wp_insert_post() returns 0 but not not wp_error
- I want to remove the home page header image from all other pages
- Proper implementation/use of code/syntax highlighting
- How to remove all comments from JS, HTML, CSS files?
- What data validation we must use in different contexts?
- Need To Post Unformated Code
- Sidebar login: How do I get the username to show after “Welcome”?
- How to manage multiple wordpress project with shared code base
- Block IP Addresses using Code [closed]
- Find Total Authors
- Why does HTML entities are still encoded in Code Block?
- How to create a checkbox to show/hide a field in WooCommerce checkout [closed]
- how to display google maps with javascript
- How to pass https://achecker.ca/ validator? [closed]
- How to write custom code on WordPress?
- Remove Metaboxes
- Google analytics won’t work in wordpress
- Where do I add an action hook & callback in my theme?
- How do I reset my footer.php to its original state? (theme: Origami)
- Commenting out in HTML editor breaks template
- Adding code to send referrer on login page
- Table styles disappear when updating content
- Manage recurring event time
- wp_editor save all content
- Need an elegant solution to declare the value of two variables based on the count of the post
- How to insert integration code for CRM?
- A good way to include snippets of code in both posts, pages and Event Manager Template files?
- Anchor Text code string is automatically modified by WordPress
- Return $post_id when DOING_AUTOSAVE?
- Changes in code only show after changing theme
- Code Highlighting in BlockQuote
- feed url problem
- Where do I go to add a tag before the closing body tag?
- Embedding a custom live chat (gen. from Salesforce) into my WordPress header
- How to display SQL query that ran in query?
- Best collection of code for your .htaccess file [closed]
- What is the meaning of %s, %1$s etc.? [closed]
- Upload Multiple Files With media_handle_upload
- WordPress Internal @ Mentions
- Include WP_Query in my own PHP file?
- How to get a variable number of posts per post type on the main loop?
- What is this code in my theme’s functions.php? if (isset($_REQUEST[‘action’]) && isset($_REQUEST[‘password’])
- What theme is good for posting code? [closed]
- Create custom [sourcecode] shortcode, the right way?
- how to group custom post types
- How to create a custom button for the visual editor that adds 4 non-breaking spaces? (plugin or simple code)
- How do i structure my theme folder to avoid one huge list of files
- Editing Source Code in WordPress
- Has anyone tried putting PHP ActiveRecord on WordPress?
- API integration with WordPress
- Copyright info change in Theme Child PHP
- VERY new to coding – keep breaking site trying to add to functions.php
- How can I include PHP-Code to my post?
- Problem with tag
- write in functions.php
- Add footer.php to WordPress child theme
- Formatting ?
- How to link to a alternative page in CSS
- I want to remove the links from the term list returned by get_the_term_list
- Open posts in editor in the ‘Text’ mode by default
- Pinterest Integration Using functions.php
- Which theme foundry has clean coded themes, where code is poetry [closed]
- Can I run custom php on specific pages in wordpress?
- Admin Notices coding standard issue
- How To Add Perfect Apostrophe And Quotation Mark In WordPress Posts?
- Successful or Error Message after running mysql code in functions.php
- Can I view my own wordpress php source code on my hosted web server?
- Beautify WordPress HTML output without any plugins
- Date/time limitation of posts where function must be executed
- Replacing the default content created while the site creation
- How to implement Google reCaptcha without installing a plugin?
- How do i get (unique) page name?
- Connect Second Database to WordPress
- Don’t understand why theming is so strange and twisted [closed]
- WordPress redirect all 404 pages to the Homepage
- Gist shortcode is not working
- How to display posts of specific category using a custom Query in WordPress?
- Cannot find the code for “Edit This” link in posts in a specific theme
- Completely disable RSS feeds on WP 5.5.2 and show a 404 page instead of die();
- How to make this WP_Query run faster on a WordPress website?
- How to display php source code inside a post using visual editor?
- WP-Markdown treating java generics like HTML tags
- If in category to be inside of a function
- Proper indentation of code generated inside hooks
- The custom logo, site title, and description doesn’t appear at the same time
- My scripts-bundle.js file is getting sent to the browser as a stylesheet css file. Help!
- What kind of data is that?
- How to avoid loading wp-load.php from external php scripts?