Array of String Search in express.js

Question

I have array of string like this

let search = ["user","country"];

I want to get data from mysql database using LIKE operator.

For example like this

searchStmnt = `u.u_fullname LIKE "%` + search + `%"`

But the above code is not working. Can anyone suggest me how to do that?

kol · Accepted Answer · 2021-08-20 06:29:34Z

2

const search = ["user", "country"];
const searchStmnt = search.map(item => `u.u_fullname LIKE '%${item}%'`).join(" OR ");
console.log(searchStmnt);

...or with REGEXP:

const search = ["user", "country"];
const searchStmnt = `u.u_fullname REGEXP '(${search.join("|")})'`;
console.log(searchStmnt);

answered Aug 20, 2021 at 6:29

kol

28.9k13 gold badges91 silver badges126 bronze badges

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

1 Answer 1