title: Searching for a specific text value in a column in SQLite3
body: <p>Suppose I have a table named 'Customer' with many columns and I want to display all customers who's name ends with 'Thomas'(Lastname = 'Thomas'). The following query shows an empty result(no rows). Also it didn't show any error. </p>
  
  <pre><code>SELECT * FROM Customer WHERE Lastname = 'Thomas';
  </code></pre>
  
  <p>While executing the following query give me correct result.</p>
  
  <pre><code>SELECT * FROM Customer WHERE Lastname LIKE '%Thomas%';
  </code></pre>
  
  <p>I would like to know what is the problem with my first query. I am using sqlite3 with Npm. Below is the result of '.show' command(Just in case of the problem is with config).</p>
  
  <pre><code>sqlite&gt; .show
       echo: off
    explain: off
    headers: on
       mode: column
  nullvalue: ""
     output: stdout
  separator: "|"
      stats: off
      width: 
  </code></pre>