I am trying to add a parameter to a MySQL query using the placeholder %VAR1%. Per the following directions on https://wpdatatables.com/documentation/table-features/using-placeholders/

"If you are using String for Placeholder ‘variable’ %VAR1% should be surrounded with Single Quote (‘)."

So in my query I added single quotes to the placeholder reference as such: '%VAR1%'. Unfortunately, the query fails. It works fine with numeric data. 

Please advise. 

I have managed to resolve this issue. 

Thank you for your help.

I had same problem and resolved by myself.

The document is not very clear, particularly this line below.

If you are using String for Placeholder ‘variable’ %VAR1% should be surrounded with Single Quote (‘) in the query.

I think the document can be improved by giving an example, for example:

SELECT * FROM users WHERE email = '%VAR1%';

@ Mark Lee:

Could you please share how you resolved this?

I'm facing the same issue… and would appriciate it.

Thx.

Not sure if what I did will help you. I actually did away with the single quotes. 

 WHERE Custid = '%VAR1%'

becomes

 WHERE Custid = %VAR1% 

Thx for your reply…

I found out through this site that the SELECT function from the SQL query is NOT supported. The FROM and WHERE statements ARE supported. Unfortunately I started with the SELECT statement and could not get it to work. (still can't). But using just FROM and WHERE got me what I need.

Again thx for taking the time to reply.