title: WHERE condition is true but not all rows are returned? (SQLite db)
body: <p>When I try to use <code>WHERE word = &quot;a&quot;</code> there is only 1 row returned when in fact there are 2 rows with the word &quot;a&quot;. As you can see in the second picture there is also another &quot;a&quot; with the id = 1. How can I query both of them?</p>
  <p><a href="https://i.stack.imgur.com/FXJOs.png" rel="nofollow noreferrer">Only 1 row is returned with <code>WHERE word = &quot;a&quot;</code></a></p>
  <p><a href="https://i.stack.imgur.com/VkW0U.png" rel="nofollow noreferrer">There are actually 2 rows with for the word &quot;a&quot;</a></p>
  <p>UPDATE: They actually have different length,
  <a href="https://i.stack.imgur.com/PIWUi.png" rel="nofollow noreferrer">one 1 and the other 2.</a></p>