The problem is not the "s." You wanted a "%" to be in the query. The corrects way to do that, as the API doc states, is with "%%". That's why it worked when you changed it. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________
From: Austin Einter str = SELECT name, id, lft, rgt FROM resubmt_skill_ids AS node WHERE ( node.name LIKE "%sip%") ORDER BY node.lft
On debugging, looks the query went as SELECT name, id, lft, rgt FROM resubmt_skill_ids AS node WHERE ( node.name LIKE "ip%") ORDER BY node.lft
Then I changed the query to
SELECT name, id, lft, rgt FROM resubmt_skill_ids AS node WHERE ( node.name LIKE "%%sip%") ORDER BY node.lft Above query returns expected records.
My question is , when a token starts with "s", we will be facing above issue. What is the best way to resolve it.