PHP - How to use strtolower in query

php lowercase
Daniel picture Daniel · Jul 28, 2011 · Viewed 36k times · Source

In database I have this field: "TeST" and I dont know where are the caps lock and I just want to strtolower him and to do somthing like that

SELECT * FROM table WHERE strtolower(field) = strtolower($var)

How can I do that?

Answer

Phil picture Phil · Jul 28, 2011

Using PDO and assuming MySQL

$stmt = $db->prepare('SELECT * FROM table WHERE LOWER(`field`) = ?');
$stmt->execute(array(strtolower($var)));

Related questions

How to convert array values to lowercase in PHP?

How can I convert all values in an array to lowercase in PHP? Something like array_change_key_case?

Read More
Make first letter uppercase and the rest lowercase in a string

All, I'm trying to insert a last name into a database. I'd like the first letter to be capitalized for the name and if they have use two last names then capitalize the first and second names. So for example …

Read More
How do I check if a string contains a specific word?

Consider: $a = 'How are you?'; if ($a contains 'are') echo 'true'; Suppose I have the code above, what is the correct way to write the statement if ($a contains 'are')?

Read More