RE: [PHP-DB] get first letter from field
| From: | John W. Holmes | Date: | Sun, 04 May 2003 22:33:52 +0000 |
| Subject: | RE: [PHP-DB] get first letter from field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27518@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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
> news:000901c31279$a0df08e0$7c02a8c0@coconut...
> > > what can i do when i want to be case sensetive
> > >
> > > thanks
> > >
> > > "Heilo" <grillen@abendstille.at> wrote in message
> > > 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