Re: list "a", list "b" ...etc
| From: | 1LT John W. Holmes | Date: | Fri, 21 Feb 2003 14:55:38 +0000 |
| Subject: | Re: list "a", list "b" ...etc | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-136510@lists.php.net to get a copy of this message | ||
> how can i sort names by first letter, like, show only names starting
> with a, then b, c .. etc
Where is the data? In an array? database? file?
If it's a database, then you can just do
SELECT * FROM table WHERE column LIKE 'a%'
or
SELECT * FROM table WHERE LEFT(column,1) = 'a'
---John Holmes...