Title: SQL Like Incompatible with
Last modified: April 3, 2022

---

# SQL Like Incompatible with

 *  Resolved [voidunnamed](https://wordpress.org/support/users/voidunnamed/)
 * (@voidunnamed)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/sql-like-operator-incompatible-with/)
 * Whenever I built SQL query with like ‘%ac’ with WP Data Access,
 * `SELECT`a`.`b` as ‘b’
    FROM `a` WHERE (`a`.`b` like ‘%%ac%’)`
 * The result will be `last_query: "SELECT`a`.`b`as 'b' FROM`a`WHERE (`a`.`b`like'%%')
   limit 100 "`.
 * It looks like %ac is some kind of reversed words. The same happens for %ad as
   for as I know.
 * Does anyone know what may cause this and how am I going to fix it?
    -  This topic was modified 4 years, 2 months ago by [voidunnamed](https://wordpress.org/support/users/voidunnamed/).
    -  This topic was modified 4 years, 2 months ago by [voidunnamed](https://wordpress.org/support/users/voidunnamed/).
    -  This topic was modified 4 years, 2 months ago by [voidunnamed](https://wordpress.org/support/users/voidunnamed/).
    -  This topic was modified 4 years, 2 months ago by [voidunnamed](https://wordpress.org/support/users/voidunnamed/).

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/sql-like-operator-incompatible-with/#post-15524036)
 * Hi [@voidunnamed](https://wordpress.org/support/users/voidunnamed/),
 * I have seen this behavior before, but I cannot reproduce it. Can you send me 
   your system info? Open plugin settings, tab System Info and click “Copy to clipboard”.
   Then go to the plugin website, open the contact form and paste your system info
   in the message with a reference to this forum issue. I’ll look into it…
 * Thanks,
    Peter
 *  Thread Starter [voidunnamed](https://wordpress.org/support/users/voidunnamed/)
 * (@voidunnamed)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/sql-like-operator-incompatible-with/#post-15525548)
 * Hi [@peterschulznl](https://wordpress.org/support/users/peterschulznl/),
 * I have submitted a contact forum. I submitted the system info as much as I can
   due to the 2048 characters limitation. Please let me know how I am going to send
   the full System Info, or if I submitted it in the wrong place.
 * Best,
    Marvin [](https://i0.wp.com/i.imgur.com/UPFBBV5.png?ssl=1)
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/sql-like-operator-incompatible-with/#post-15531400)
 * Thank you Marvin,
 * I don’t see any issues in your configuration. Can you check the request?
 * Please try this:
    – Start the Query Builder – Open the Network tab of the inspector–
   Send the query that results in an error – Check the request: Please check wpda_sqlquery
   in payload And cmd in preview
 * Is the query send and processed correctly?
 * Thanks,
    Peter
 *  Thread Starter [voidunnamed](https://wordpress.org/support/users/voidunnamed/)
 * (@voidunnamed)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/sql-like-operator-incompatible-with/#post-15543466)
 * Hi Peter,
 * Yes, the query is sent correctly.
    wpda_sqlquery: SELECT `a`.`b` as ‘b’ FROM `
   a` WHERE (`a`.`b` like ‘%%ac%’)
 * The response becomes to “last_query”: “SELECT\t`a`.`b` as ‘b’\nFROM\t`a`\nWHERE\
   t(`a`.`b` like ‘%%’) limit 100 “.
 * Best,
    Marvin
    -  This reply was modified 4 years, 1 month ago by [voidunnamed](https://wordpress.org/support/users/voidunnamed/).
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/sql-like-operator-incompatible-with/#post-15552027)
 * Hi Marvin,
 * Problem found and fixed! The fix will be available after the next update.
 * Thank you for your patience and cooperation,
    Peter
 *  Thread Starter [voidunnamed](https://wordpress.org/support/users/voidunnamed/)
 * (@voidunnamed)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/sql-like-operator-incompatible-with/#post-15620139)
 * Hi Peter,
    Thanks for fixing the bug. After upgraded to the latest version, the
   query function works well. I found that the same problem still holds in URL filter
   via GET Method. For example, /?wpda_search_column_a=%ac% still cannot be executed
   correctly. Best, Marvin
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years ago](https://wordpress.org/support/topic/sql-like-operator-incompatible-with/#post-15629449)
 * Hi Marvin,
 * My apologies for my late reply! During my stay in Aruba I was not able to recharge
   my laptop battery which was limiting my internet access.
 * I can reproduce this issue! Sorry, it must have been late. 🙈 I’ll fix it before
   I deploy the next version.
 * Thanks again for your contribution 👍
    Peter

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘SQL Like Incompatible with’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

## Tags

 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 7 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [4 years ago](https://wordpress.org/support/topic/sql-like-operator-incompatible-with/#post-15629449)
 * Status: resolved