title: Why do i get different Query result on PHP App and PhpMyAdmin? what is proper way to do strict/normal search?
body: <p>I have request that works well on PhpMyAdmin but doesn't show same result on my PHP application.</p>
  
  <p>my Table looks like this: </p>
  
  <pre><code> table_one
  id| title
  1 | title 01
  2 | title 02
  3 | title 03
  etc.. &lt;= 11
  </code></pre>
  
  <p><strong>id</strong> is INT and <strong>title</strong> is VARCHAR(50)</p>
  
  <p><strong>Request A</strong> (strict):</p>
  
  <pre><code>SELECT * FROM table_one WHERE title LIKE 'title 01'
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT * FROM table_one WHERE title = 'title 01'
  </code></pre>
  
  <ul>
  <li>result on PhpMyAdmin <code>1 | title 01</code> </li>
  <li>result on PHP App <code>(nothing)</code></li>
  </ul>
  
  <p>it should display only title 01 values and nothing else</p>
  
  <p><strong>Request B</strong> (non strict):</p>
  
  <pre><code>SELECT * FROM table_one WHERE title LIKE '%title 01%'
  </code></pre>
  
  <ul>
  <li>result on PhpMyAdmin <code>1 | title 01</code> </li>
  <li>result on PHP App  <code>all values from 0 &lt;=10 (does not display 11)</code></li>
  </ul>
  
  <p>if i will request <em>title 0</em> it should display all titles that start with title 0 like 01 02 03 04 etc &lt;= 09 (i think this command is '%title 01' but its not working)</p>
  
  <p>my php code is like this: </p>
  
  <pre><code>switch($Request){
      case 'A': $result = mysqli_query($con,"SELECT * FROM table_one WHERE title LIKE 'title 01'"); break;
      case 'B': $result = mysqli_query($con,"SELECT * FROM table_one WHERE title LIKE '%title 01%'"); break;
  }
  while($row = mysqli_fetch_array($result)) {
      for($i=0; $i&lt;(count($row)/2); $i++)
      {
          echo " " . $row[$i] . " ";
      }
  }
  </code></pre>
  
  <p>it works well on PhpMyAdmin but doesn't work properly on my PHP Application.</p>
  
  <p>what am i missing? </p>
  
  <p>i need some kind of <strong>strict</strong>/<strong>non strict</strong> search: </p>
  
  <ol>
  <li>in <strong>STRICT</strong> mode, when i write <strong>title 01</strong> it should display only values which's title <strong>is</strong> title 1  instead of full table.</li>
  <li>in <strong>non Strict</strong> mode (normal) when i write title 01 it should display any values which's title <strong>contains</strong> title 01</li>
  </ol>