title: Using java for searching for data by using part of the row in microsoft access database
body: <p>I have this table</p>
  
  <p><a href="https://i.stack.imgur.com/YV20y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YV20y.png" alt="enter image description here"></a></p>
  
  <p>And I am using the following code to retrieve data from my table
  that returns all the English words that its Kurdish word contains بةرز</p>
  
  <pre><code>targetText="بةرز";
  try (PreparedStatement ps = conn.prepareStatement(
  "SELECT English,Kurdish FROM Info " +
  "WHERE Kurdish = ? " +
  "OR REGEXP_MATCHES(Kurdish, ?) " +
  "OR REGEXP_MATCHES(Kurdish, ?) " +
  "OR REGEXP_MATCHES(Kurdish, ?) ")) {
     ps.setString(1, targetText);
     ps.setString(2, "^[. ]*" + targetText+ "[ ]*[:،,]+[ .]*$");
     ps.setString(3, "^[. ]*[:،,]+[ ]*" + targetText+ "[. ]*$");
     ps.setString(4, "^[. ]*[:،,]+[ ]*" + targetText+ "[ ]*[:،,]+[  .]*$");
     try (ResultSet rSet = ps.executeQuery()) {
        while (rSet.next()) {
           System.out.println(rSet.getString("English"));
           System.out.println(rSet.getString("Kurdish"));
        }
     }
  }
  </code></pre>
  
  <p>So it works fine, it prints all the English words that I want.<br>
  My problem is that when I get the corresponded Kurdish word it doesn't print the complete cell. It just prints بةرز,<br></p>
  
  <p>For example the output of the previous code should be:</p>
  
  <pre><code>aesthete
  بةرز ، جوانىثةرست
  aether
  زوَر ناسك ، بةرز ، ثيروَز ، ئاسمانى
  affair
  بةرز 
  </code></pre>
  
  <p>But it prints</p>
  
  <pre><code>aesthete
  بةرز 
  aether
  بةرز 
  affair
  بةرز 
  </code></pre>
  
  <p>What can I do to get the output that I want?</p>
  
  <p>Note that I am using <code>UCanAccess</code> for my database connection,</p>