mySQL where in 子句

Question

是否可以用 where in 子句做这样的事情，我需要使用 where in 查询以下数据。

select *
FROM instructor AS i
INNER JOIN teaches AS t ON i.id = t.ID
where course_id in ('C%'); -I want every course ID that begins with C

Answer 1

使用LIKE:

select *
FROM instructor AS i
INNER JOIN teaches AS t ON i.id = t.ID
where course_id LIKE 'C%';