title: Selecting records with underscore as second character in a column in MySQL using 'like'
body: <p>I know for selecting the records with 'a' as the second letter in a column we write the following query:-</p>
  
  <pre><code>Select * from table where column1 like '_a%';
  </code></pre>
  
  <p>For selecting the records with 'a' as the third letter in a column we write:-</p>
  
  <pre><code>Select * from table where column1 like '__a%';
  </code></pre>
  
  <p>Now I want select the records where the <code>column1</code> contains '_'(underscore) as the second character.For example, I want to select the records with <code>column1</code> like A_John, B_John, A_Jai and so on. What is the escape character I can use in this case. How can I do that? Please help.</p>