const sql = 'SELECT * FROM mytable WHERE mycolumn LIKE ?'; const result = await connect.execute(sql, [`%${value}%`]);