title: Zend: How to fetch record from Database without considering case sensitive?
body: <p>I am using Zend Framework. I want to fetch record from database without considering case sensitive.</p>
  
  <p>This is my Person Table:</p>
  
  <pre><code>Id|Name  |Gender|Occupation
  -----------------------------------
  1 |Naveed|Male  |Software Engineer
  -----------------------------------
  2 |Ali   |Male  |Software Developer
  </code></pre>
  
  <p>Now If I use the following strings to search for a record in above table using 'Occupation' in where clause, it should always return record number 1 (Naveed's Record).</p>
  
  <pre><code>Software Engineer
  software engineer
  SoFtwarE EngIneeR
  SOFTWARE ENGINEER
  </code></pre>
  
  <p>I am using following way to fetch records from database in Zend.</p>
  
  <pre><code>$occupation = "Software Engineer";
  $table = new Model_Person_DbTable();
  $select = $table-&gt;select();
  $select-&gt;where( 'Occupation = ?', $occupation ); 
  $rows = $table-&gt;fetchAll( $select );
  </code></pre>
  
  <p>Now how to change above zend code for my scenario ?</p>
  
  <p>I can create a logic to ignore case sensitive outside database query but I want to know If there is any way in Zend/SQL to handle this issue in query.</p>
  
  <p>Thanks</p>