This is probably because of your database collation. There are numerous questions on StackOverflow about this sort of thing. Your question may get closed or migrated as it’s not on-topic for wordpress.stackexchange.com;
Take a look at this question, or perhaps ask there instead.
Also, why are you not using the WordPress WP_Query class to return posts?
Related Posts:
- Run WP-CLI using PHP
- Disable email notification after change of password
- How to remove duplicate sub-menu name for top level menu items in a plugin?
- Plugin update error message
- How to build an API as a plugin
- category_name not working (not showing up in sql query debug)
- Difference between deactivating, uninstalling, and deleting plugins
- Update Multiple Post Meta for the Same Post In One call?
- WordPress Hook that will run when media file deleted
- Set a User as Author of all ‘New Posts’ posted
- How do I configure WordPress to talk to a Microsoft SQL Server database?
- Post source link plugin – small modification
- Calling function from within functions.php returns unwanted value
- How can I make the “Preview Post” button save and preview in the same window?
- Cannot run the code after I activate the plugin
- Displaying admin notice dynamically
- Calling a plugin in theme development
- Unable to activate wordpress importer after installing it
- Get total number of comment of the posts written by an author
- force customers to add only single item to card per purchase EDD [closed]
- How to get post URL in the_content filter?
- Write to / remove from default .htaccess file from plugin?
- WordPress Ajax Callback
- printf – problem to understand code
- Why isn’t admin_notices displaying my text? [Simple Plugin, Beginner]
- add_query_arg not working
- How to Use Parameters with a Do_Action Function Within PHP Tags
- How do I pass a post ID to the page URL?
- How would I go about creating a user ranked post popularity page?
- WordPress: PHP code rendering in the wrong place
- New to wordpress, Question about editing PHP
- How to edit content before post update
- Bootstrap and Custom CSS in custom plugin are being overwritten by theme
- Customize permalink wordpress category id
- Take input from form and pass it to function using a wp-plugin
- Self-serve ad system like Reddit’s for WordPress? [closed]
- Create a plugin from within WordPress
- Class variables not correct on page
- Load Javascript from Plugin in One Page Only?
- Why is one phpunit test throwing an error on one class when all other classes are similar without error?
- WordPress call_user_func_array() expects parameter 1 to be a valid callback, class
- Call plugin with php function
- Why is my custom post type not being activated on plug-in activation?
- Setting Up PHP Workflow in WordPress
- How can I exclude a dynamic URL to show a popup created using ‘WordPress Popup’ plugin
- iframe not showing in post (with “allow php in posts” plugin activated)
- how can I do something on new user registration?
- Any idea how to get something like this to work? [closed]
- output html on post or page from custom plugin [closed]
- Api external with wordpress
- speed up pagination for huge database
- Using meta_query in a WP_Query not working for numbers properly
- File Uploader – Upload without adding to Media Library
- Building a plugin into a theme
- Trying to include files in plugin isn’t working
- Code for unique user visit count on every page WordPress
- Searching a tab/space delimited text file based upon form criteria and returning a ‘record’ into a word press results page
- implement custom roles in custom plugin
- How to get current cart values using WC_Shortcodes?
- WordPress is redirecting me to homepage
- How can we get this dynamically as this folder may not be by the same name always → wp-admin
- Cant create table on plugin activation
- Circumvent WP CLI Command
- Redirect to a page while maintaining search query parameters without causing an infinite loop
- How to ignore fields if empty?
- Why is my shortcode not working?
- Moving a few select DB tables to a new WP instance
- implement checkbox or toggle switch in plugin code
- Create a form and have custom menu display based on user answers?
- How to get the total count of Favorite/Favorited authors
- Admin login substantially slower on production server
- redirect to a custom page
- Problem with conditional woocommerce custom checkout field
- How to change text in a page by utilizing a custom user id?
- How can I insert a record into a custom table from my custom form in my custom admin page?
- How to save information related to post in database?
- Save selectlist value (taxonomy) in wp:wp_set_object_terms
- Page doesn’t load
- Metabox Data not saving
- conditional tags for the output of a plugin
- Xml output not places where i want
- Can’t insert files in other inputs
- Including a PHP file via a function that is part of a plugin?
- How do I output user_registered time in my correct timezone?
- How to fix ‘Call to undefined function do_settings()’ error?
- How to tweak a plugin without preventing it from updating
- Place max_execution_time in plugin [closed]
- Creating a press page for our project
- how to search through plugin in wordpress cimy-user-extra-fields?
- Integrate Razorpay quick payments plugin with contact form7 plugin
- wordpress illegal string offset ‘parameter’ error
- Translate text for empty product
- Passing an input variable through a switch statement
- How to get URL param for pagination in shortcode?
- Make plugin admin page visible to other roles
- Is there any WordPress Plugin that provides video editing from front end side? [closed]
- Disappearing plugins
- How Create LastMod and Update Date Only on Taxonomy Category and Tags
- Accessing Correct Database to Create REST API Endpoint
- How do I replace a logo image that’s hard-coded into a plugin’s logo.php file?