How to have string like query to find an account in ZOQL similiar to SQL which contains a substrin ?

[akhilvashisht]

Hi Team,

Would you please tell how to fetch the result using Action query API provided by Zuora using the substring . I am getting no result each time or some error for malformed ZOQL. I am able to get the result by using %age for leading and trailing in the like query of ZOQL but if i need to search something in the middle than i could not able to find.

POST: https://rest.apisandbox.zuora.com/v1/action/query

Request Body:

{
"queryString": "SELECT Id FROM account WHERE name like '%Akh'"
}

 This gives result name = Akhil with id of the account

{

"queryString": "SELECT name FROM account WHERE name like '%khi%'"

}

This doesn't give result provide your inputs.

I tried couple of permutaion and combination but failed to get the desired result. Please suggest