Upper/Lowercase in MySQL/PHP

[Gibbs]

I noticed that if I get "Name" from a MySQL database the results are different to getting "name". Is it possible to counter this without having to change "Name" or "name" in PHP?

[Ninjakreborn]

Yes, there is something to change the first letter to capital, or non-capital.
Not sure what it was called, if not regular expressions.

[se1zure]

you can use a sting modifier to convert all letters to lowercase, all to uppercase, or you can use an ignorecase.
I'm not sure about using it in mysl, but I know that ther is something along the lines of:

ingnore.case("")

Not exact though.

[hackerkts]

Hope this helps [url=http://www.php.net/manual/en/function.strtolower.php]strtolower()[/url]

[bibby]

[code]
# stuff i just ran on mysql 4.1

SELECT name FROM table WHERE 1 AND name="[b]myname[/b]";
# returns  '[b]MyName[/b]' from table.


[b]select [/b]name from table where name='banner'
# would return [b]Banner[/b]
[/code]