title: How to select all where column data begins with certain numbers in MySQL
body: <p>This is my table:</p>
  
  <pre><code>studentID   lastName  firstName
  08422567    Brown     Susan
  10356844    Black     Roger
  10659475    White     Steven
  09463729    Grey      Naomi
  </code></pre>
  
  <p>I am trying to select all students whose ID begins with 10, so basically Roger and Steven.</p>
  
  <p>Here are examples of what I was trying:</p>
  
  <pre><code>SELECT * FROM student WHERE studentID='10356844' AND  studentID='10659475'
  SELECT * FROM student WHERE studentID='10356844,10659475'
  </code></pre>
  
  <p>Would I need to use regular expressions for this, surely there must be a simpler way to run a query like this? In the future there may be 100 number beginning with 10, I cannot add all of these to a query, and the difficulty of this is why I ask this question here, in order to get the correct solution.</p>