Search for a specific letter in a specific spot within a varchar in SQL
<p>I would like to search my database for any varchars with 'C' as the second letter. </p>

<p>I have tried   "like '%C%'"   but that returns values with C anywhere. </p>

<p>I am using mysql just in case that matters.</p>