Is it possible to use the 'IN' operator using such a code:
- Code: Select all
var paramsArray = [x,y];
var sqlString = 'UPDATE table_name SET field_1 = 1 WHERE field_y IN ?';
var done = plugins.rawSQL.executeSQL('server_name','table_name',sqlString,paramsArray);
Thanks in advance.