title: MYSQL SELECT WHERE LIKE WITH AES_ENCRYPT
body: <p>How would I perform a Mysql SELECT with WHERE and LIKE serach if field is AES_ENCYPTED?</p>
  
  <p>Example:</p>
  
  <pre><code>SELECT AES_DECRYPT(place,'"+salt+"'),AES_DECRYPT(web_address,'"+salt+"') 
  FROM access 
  WHERE place= LIKE '%(AES_ENCRYPT('"+searchStr+"','"+salt+"'))',%')
  </code></pre>
  
  <p>Basically, perform a search on an encrypted column with the LIKE wildcard on both ends of the <code>$searchStr</code></p>