javascript - "where in" MySQL query in nodejs - Stack Overflow

admin管理员组

文章数量:1186421

I need to make MySQL query using "WHERE IN". This is my query:

var myQuery = 'SELECT uid FROM ' +tableName+ ' where Gender IN (' + Info.Gender.join() + ')';

If i print Info.Gender it will be ['Male', 'Female'], as a string. but when the query is done it says

SELECT uid FROM appUsers where Gender IN (Male, Female)

But should be:

SELECT uid FROM appUsers where Gender IN ('Male', 'Female')

That means it takes the Female not as a string.

Any ideas?

I need to make MySQL query using "WHERE IN". This is my query:

var myQuery = 'SELECT uid FROM ' +tableName+ ' where Gender IN (' + Info.Gender.join() + ')';

If i print Info.Gender it will be ['Male', 'Female'], as a string. but when the query is done it says

SELECT uid FROM appUsers where Gender IN (Male, Female)

But should be:

SELECT uid FROM appUsers where Gender IN ('Male', 'Female')

That means it takes the Female not as a string.

Any ideas?

• javascript
• mysql
• node.js
• where-clause

Share Improve this question Follow edited Dec 22, 2016 at 13:25 Dan The Man asked Dec 16, 2015 at 10:22 Dan The ManDan The Man 1,89577 gold badges3131 silver badges5252 bronze badges 2

• 1 ' where Gender IN (\'' + Info.Gender.join("', '") + \'')'; – fuyushimoya Commented Dec 16, 2015 at 10:24
• 1 When you're generating SQL in javascript, it's smart to always use double quotes, so you can be sure that any single quotes will be part of the SQL and not of the javascript. – SWeko Commented Dec 16, 2015 at 10:29

Add a comment  | 

3 Answers 3

Sorted by: Reset to default 27

You should use query escaping (provided that you're using node-mysql):

var myQuery = 'SELECT uid FROM ?? where Gender IN (?)';
connection.query(myQuery, [ tableName, Info.Gender ], ...);

You need single quotes in your query:

var myQuery = "SELECT uid FROM " +tableName+ " where Gender IN ('" + Info.Gender.join("','") + "')";

You can pass the Info.Gender as array too:

var myQuery = `SELECT uid FROM users where Gender IN (?)`
var arrayData = ['Male', 'Female']
connection.query(myQuery, [arrayData])

本文标签： javascriptquotwhere inquot MySQL query in nodejsStack Overflow