MySQL query WHERE with object as result

Question

I'm searching data.mesaj in mySQL query but connection is running cause query isn't running, what will do now also data.mesaj have, but I don't want this:

data = { mesaj: '\nHello', uid: 'mustafa' }

y=data.mesaj;
var row = [];
connection.query('select * from yapay_zeka where yapay_zeka.soru = y ', function (err, rows) {
    if (err) {
        console.log(err);
    } else {
        if (rows.length) {
            for (var i = 0, len = rows.length; i < len; i++) {
                row[i] = rows[i];
                console.log(row);
            }  
        }
    }

and error is `{ [Error: ER_BAD_FIELD_ERROR: Unknown column 'y' in 'where clause'] code: 'ER_BAD_FIELD_ERROR', errno: 1054, sqlState: '42S22', index: 0 } ` — Mustafa Deniz, Feb 02 '16 at 22:44
Instead of burying important information in the comments, [edit] your question to provide it there instead, where it can be seen and properly formatted. — Ken White, Feb 03 '16 at 00:46

score 1 · Answer 1 · answered Aug 30 '19 at 09:17

1

    
 connection.query("SELECT * from yapay_zeka WHERE yapay_zeka = '"+y+"'", 
          function(err, data) {});

    
 connection.query("SELECT * from yapay_zeka WHERE yapay_zeka = '"+y+"'", 
          function(err, data) {});

answered Aug 30 '19 at 09:17

Gtm

465
4
12

score 0 · Answer 2 · edited Feb 03 '16 at 05:17

0

I found it:

connection.query("select * from yapay_zeka where yapay_zeka.soru = ?',[data.mesaj]

edited Feb 03 '16 at 05:17

ρяσѕρєя K

132,198
53
198
213

answered Feb 03 '16 at 01:31

Mustafa Deniz

1,619
1
10
8

MySQL query WHERE with object as result

2 Answers2