Re: [PHP] small and big letter in WHERE statement

2004-06-14 Thread Ulrik S. Kofod
John Nichel sagde: > QT wrote: >> Dear Sirs, >> >> When I use where statement, I see that there is no meaning small and big >> letter. Without looking small caps or big, result comes back. But I want to >> match only small letters. How can I do that? >> >> Best REgards >> > > Where statement for w

Re: [PHP] small and big letter in WHERE statement

2004-06-14 Thread John Nichel
QT wrote: Dear Sirs, When I use where statement, I see that there is no meaning small and big letter. Without looking small caps or big, result comes back. But I want to match only small letters. How can I do that? Best REgards Where statement for what? MySQL? If so, I don't think you can do it o

RE: [PHP] small and big letter in WHERE statement[Scanned]

2004-06-14 Thread Michael Egan
The following may help: http://dev.mysql.com/doc/mysql/en/Case_sensitivity.html Cheers, Michael Egan -Original Message- From: QT [mailto:[EMAIL PROTECTED] Sent: 14 June 2004 18:36 To: [EMAIL PROTECTED] Subject: [PHP] small and big letter in WHERE statement[Scanned] Dear Sirs, When I

Re: [PHP] small and big letter in WHERE statement

2004-06-14 Thread Angel Freire
I'm guessing that you mean in a SQL sentence. Well, depending on what SQL engine're you using it's case sensitive or not. MySQL don't take diferent case as diferent string, thats why is the 'binary' date type. In that case you have two alternatives, or change the field type to binary, or cast it

[PHP] small and big letter in WHERE statement

2004-06-14 Thread QT
Dear Sirs, When I use where statement, I see that there is no meaning small and big letter. Without looking small caps or big, result comes back. But I want to match only small letters. How can I do that? Best REgards -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http