Re: Find rows by 1st letter in MySQL
| From: | DL Neil | Date: | Sun, 18 Aug 2002 22:42:44 +0000 |
| Subject: | Re: Find rows by 1st letter in MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-113165@lists.php.net to get a copy of this message | ||
Tony,
> How would I go about selecting rows from a MySQL table where the first
> letter of a certain field is $letter ?
Depends upon the MySQL tbl's schema.
The MySQL online manual discusses wildcards (full text).
Alternatively see LEFT() and other string functions that can be used in
SELECT and WHERE clauses.
Regards,
=dn