Try
Select blah from blah where blah like '$letter%'
% is wildcard after first letter
Regards.
---
Chris Kay
Technical Support - Techex Communications
Website: www.techex.com.au Email: [EMAIL PROTECTED]
Telephone: 1300 88 111 2 - Fax: (02) 9970 5788
Address: Suite 13, 5 Vuko Place, Warriewood, NSW 2102
Platinum Channel Partner of the Year - Request DSL - Broadband for Business
---
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Monday, 19 August 2002 8:43 AM
To: Tony Harrison
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Find rows by 1st letter in MySQL
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php