CODE EXAMPLE FOR PHP

codeigniter AES _ENCRYPT or AES_DECRYPT in where

like( 'AES_DECRYPT(email,"'.KEY.'")', $email, 'both')