如何在哪里设置条件。续写mysql

Question

应该在coursesOffered数组中找到值'search‘的所有教师。

表教师

名为lastName道布coursesOffered

胡安·佩雷斯2022/10/02“数学”，“科学”

marcos smith 2022/10/02“历史”，“文学”

查询对进行后缀

const search = 'math';

const teachers = await Teacher.findAll({
    where: should fetch all teachers where the value 'search' is found in the coursesOffered array.
})

Answer 1

您可以尝试JSON_CONTAINS函数。

// When you are doing string search, make sure to wrap the search term with "".
const teachers = await Teacher.findAll({
    where: Sequelize.fn('JSON_CONTAINS', Sequelize.col('coursesOffered'), `"${search}"`)
})