It's the name of your column that you want to search the first character in.... ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -----Original Message----- > From: buttoz [mailto:buttoz@012.net.il] > Sent: Sunday, May 04, 2003 3:22 PM > To: php-db@lists.php.net > Subject: Re: get first letter from field > > hi , > what the meaning of column , is a name of field or reserved word or other? > > thanks, > buttoz > > "John W. Holmes" <holmes072000@charter.net> wrote in message > 000901c31279$a0df08e0$7c02a8c0@coconut">news:000901c31279$a0df08e0$7c02a8c0@coconut... > > > what can i do when i want to be case sensetive > > > > > > thanks > > > > > > "Heilo" <grillen@abendstille.at> wrote in message > > > BADAFFB3.29A2%grillen@abendstille.at">news:BADAFFB3.29A2%grillen@abendstille.at... > > > hi! > > > > > > SELECT `customer` FROM `customerList` WHERE `customer` LIKE "A%" > > > > Try: > > > > SELECT customer FROM customerList WHERE BINARY LEFT(column,1) = 'a' > > > > BINARY will make the comparison case sensitive. Should be able to use > > the same method with LIKE if you're using that instead of LEFT. > > > > ---John W. Holmes... > > > > PHP Architect - A monthly magazine for PHP Professionals. Get your copy > > today. http://www.phparch.com/ > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
