MYSQL Query to find an element of an Array

Question

I have a column where data is saved in the following syntax:

Value1;Value2;Value3

I have an array and I would like to check if any of the elements contain a value in the table. I read a little bit and found that the SQL Query:"WHERE...IN.. should do this but I havent done it successfully right now. Here is my command:

db.query(

'SELECT * FROM blocklist WHERE BanContent IN ?', [inputarray.join(",")],
function (err, results) {
    try {

        console.log(results)

    } catch (err) {
        console.log(err);
    }

});

I allways get undefined as the result.

IN requires the values it should check for to be in parenthesis. — waka
– waka, Commented Sep 14, 2017 at 13:31
Can i give you example of PHP PDO Query? but i think you are using Console? im not familiar with console. — Ajmal PraveeN
– Ajmal PraveeN, Commented Sep 14, 2017 at 13:32
"select * from blocklist where BanContent IN ", [inputarray.join(",")], function (err, results) — Chetan_Vasudevan
– Chetan_Vasudevan, Commented Sep 14, 2017 at 13:35
Why not, maybe it helps. @waka is there a sql query which work the way I need it or do i need to for loop every array element. Would not be the worst case since the array I want to check is not that big. — soileh
– soileh, Commented Sep 14, 2017 at 13:38

Strawberry · Accepted Answer · 2017-09-14 13:41:53Z

1

Consider the following:

SELECT FIND_IN_SET('v2',REPLACE('v1;v2;v3',';',','))x;
+---+
| x |
+---+
| 2 |
+---+

And now see about normalisation and why it's a bad idea to store delimited data in an RDBMS.

answered Sep 14, 2017 at 13:41

Strawberry

34k14 gold badges43 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

MYSQL Query to find an element of an Array

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