Check if MySQL row exists - Node.JS

Question

I am making a Discord bot which uses MySQL, but that shouldn't matter, I am trying to do a blacklist database so users in it can't use my bot

This is what I got so far:

con.query("SELECT EXISTS( SELECT 1 FROM `blacklist` WHERE `id` = '"+message.author.id+"')", function(error, result, field) {
    if(error) throw error;
});

And this kinda works, this is my output

[ RowDataPacket {
'EXISTS( SELECT 1 FROM `blacklist` WHERE `id` = \'227090776172134400\')': 1 } ]

And the last digit works like a boolean, 1 if the row exists, 0 if it does not But my problem is, that I can't seem to figure out how to check if it's a zero or not because it's an object

Take a look at this answer on how to access the property of an object — Michael Russo
– Michael Russo, Commented Dec 29, 2017 at 18:17

johnny_mac · Accepted Answer · 2017-12-29 18:18:08Z

0

Why can't you make the query string a variable that you can later query on. For example:

let conStr = "SELECT EXISTS( SELECT 1 FROM `blacklist` WHERE `id` = '"+message.author.id+"')";
con.query(conStr, function(error, result, field) {
    if(error) throw error;
    console.log(result[conStr]); //--> 1
});

answered Dec 29, 2017 at 18:18

johnny_mac

1,9914 gold badges25 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Check if MySQL row exists - Node.JS

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related