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?
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);