Re: small and big letter in WHERE statement
| From: | John Nichel | Date: | Mon, 14 Jun 2004 15:14:11 +0000 |
| Subject: | Re: small and big letter in WHERE statement | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-188220@lists.php.net to get a copy of this message | ||
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 REgardsWhere statement for what? MySQL? If so, I don't think you can do it on the SQL end as WHERE is normally case-insensitive. You could use a regular expression while looping thru your result set. -- John C. Nichel KegWorks.com 716.856.9675 john@kegworks.com