mySQL where in clause -

Is it possible to do something like this where in the section, I need a query using data from < / P>

  Select from trainer I teaches TS at i.id = t.id at INNER JOIN, where course_id in ('C%'); - I want every course ID which starts with  

1. I want every course ID which starts with

2. is there any way to complete it ? This is necessary to use my - fatal propetate

You can compare the first letter of data with the desired letter.

Example :

  - Inputs for other matches are different letters than commas where LEFT (course_id) , 1) in ('c')