How to search on the field that stores escaped strings?

I think what TheDeadMedic is trying to say, is your data in SQL should not have escapes. You will want to run queries to remove the escapes, but that can be complicated. Until that is done, you will not be able to search for “Application’s Document” and get back any results.

When escaping strings into the database, your best option is to use prepared statements. It is the most secure way to avoid breaking SQL statements with the ‘ character, and it also prevents SQL injection.

However, if you are on an older server that doesn’t support it, you will have to use an escaping function. In PHP, MySQL has the method mysql_real_escape_string($value) which will do it for you. Just wrap all your varibles in that. It’s better than nothing.

Related Posts:

  1. How do I improve this admin query snippet to avoid generating duplicate results on non-meta searches?
  2. How to make dynamically-generated content searchable in WordPress?
  3. Displaying search results in the widget itself?
  4. modify wordpress default search
  5. what are the checksums surrounding keywords in the SQL generated by WP_Query and do I need to use them too?
  6. Search the product by tag or category not working
  7. Search and Filter
  8. Using ob_get_content to get_search_form puts into infinite loop
  9. How can I replace the search results displayed by WordPress?
  10. Showing results from json-string in WordPress search results page
  11. Ajax action has 200 status but response of No response data available for this request
  12. ajax stopped working when not logged in wordpress
  13. Get search result count in plugin
  14. Generate Static Page to Show Search Results/Detail for API
  15. Modify search form with plugin
  16. WP Query Relations / Compare
  17. WordPress Search Form with Keyword Suggestion
  18. Simple Search Plugin Does Not Perform Search
  19. Change the search results header from plugin
  20. How to create a custom search form and handler?
  21. Get custom wp_query search results to appear on search.php
  22. Why is WordPress wrapping search for users that looks like integers with asterisks and how do I fix it?
  23. Hook a search form anywhere on the site, using a custom plugin
  24. Is there any plugin development framework
  25. Plugin – create a page without it appearing in the side menu
  26. Is wp-content/install.php a Drop-in?
  27. Handling results from data hooked into admin_post
  28. How to write testable classes in WordPress
  29. get_template_part from plugin
  30. Edit or Remove Plugin .htaccess Using The Admin Panel
  31. WordPress scheduled task is called but not executed
  32. How to create collections that are edited in admin?
  33. How can I call “preview post” from wp_remote_get with authentication?
  34. When is it too late to call the action wp_enqueue_scripts?
  35. Use js script from one plugin in another plugin
  36. Rest Api How to get results of child categories with one api call
  37. Build dynamic page from cURL (HTML page) response with plugin
  38. How to store accumulate multiple option values in a single array using Options_API
  39. template_redirect for single posts w/ custom fields
  40. can I prevent WP users (even admin) from deleting custom categories?
  41. How to deal with equal & similar arguments for a function?
  42. What parameter should I pass to wp_enqueue_style to depend on the themes stylesheet?
  43. How do I obtain a list of categories assigned to the current post?
  44. Modify hard-coded conditionals for roles to custom roles
  45. need to get user ID after a user logs in
  46. Callback is not called in add_settings_field() when passed as part of an array, but recognises that it’s there. It’s passed Class to Class using OOP
  47. Plugin translations not installed but… strings are translated!
  48. Secure Pages Best Practice
  49. Does wp_login only trigger before an user signs in into the admin panel?
  50. How to access noticeOperations from withNotices
  51. Putting a resized image into media library with wp_get_image_editor(
  52. Using ReactJS in the WordPress admin for plugin development
  53. How to use github to update my plugin
  54. wp_nonce_field displaying twice
  55. jQuery in WordPress Plugin
  56. Why is my plugin version 0.1?
  57. Settings API – format container of setting and setting’s description
  58. Delete option of a Plugin
  59. How to include jQuery into my plugin so I can use it on plugin page?
  60. Apply function to update_option Variable
  61. Proper way to include stylesheet for panels
  62. How to make and save custom form in custom plugin page?
  63. WordPress Gutenberg InnerBlocks renderAppender not showing with template
  64. Duplicate shipping method logic to another shipping method [closed]
  65. REST Endpoint API 404
  66. Add a custom menu item that supports wildcards
  67. jQuery UI tab does not work in the plugin page
  68. Using HTML links within translatable string
  69. Adding an external stylesheet to a plugin
  70. How to share user data across multiple WordPress websites?
  71. Load stylesheet in edit category page?
  72. How to add .ini file type to the plugin editor to read and edit?
  73. How to write a custom shortcode name book?
  74. get the term_id of current taxonomy page
  75. WordPress Ajax not returning Response
  76. Add a Script button in W3 Total Cache plugin not working due to conflicting jQuery version
  77. Remove from a div by class name from post page if post author role is not administrator
  78. Enqueue script not working
  79. Calling dynamic_sidebar in plugin gives error
  80. Best way to handle a form post in plugin
  81. Method to retrieve category names and IDs only as an array?
  82. How To Remove The Filter That Adds JetPack Related Content To Dom [closed]
  83. Fixing plugin for wpdb::prepare
  84. Using “add_image_size” to register custom image sizes inside plugins not working
  85. How do I access the contents of WordPress Classic editor in admin area with JavaScript?
  86. Safe XML response from wordpress plugin
  87. Gutenberg: – Call a function after Server Side Component is rendered
  88. How are themes and plugins localized using the gettext GNU framework?
  89. Theme, Plugin or Both?
  90. Accept only PDF file for upload
  91. WordPress upload path decalration
  92. Add a custom image source
  93. filter on get_posts efficiently
  94. How to get custom user meta by id in custom Gutenberg block
  95. How to prepend a header section to all pages related to my WordPress Plugin
  96. How to access Elementor-navigation-elements via jQuery
  97. Plugin forms overwrite each other’s options
  98. ACF – programmatically install and activate in pipeline to automate testing for custom plugin development?
  99. How can I include React useState in a custom gutenberg block plugin?
  100. Problem with Owl Carousel, infinite loop [closed]