I'm querying for an email address where I can't force the case of the search term or the data in the table. It's an API thing.
How can I convert this query to be case insensitive?
$results = db_query( 'SELECT email_address FROM email_address_table WHERE (email_address LIKE :mail)', array(':mail' => '%' . db_like($mail) . '%') )->fetchAll();