In Node.js Mysql Query, Check If No Matching Found

How can I check if no matching found in mysql (node.js)? mysql.query('select * from table1 where name = 'abcd'', function(error, result, field) { if(error) { exist(erro

Solution 1:

You're receiving an empty array ([]) as result of your query, because as you said, your database does not contain any row with name = 'abcd'.

When you do:

if (result) {
  if (result)
    console.log("Test:" + result);

, you'll enter the if, because JavaScript evaluates true for []. Take a look at this article here, that explains how JavaScript evaluates true and false values.

A better way to check if your result array is empty is to do:

if (result.length > 0) {
  if (result)
    console.log("Test:" + result);