Re: [PHP] Find rows by 1st letter in MySQL

2002-08-18 Thread DL Neil 

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

RE: [PHP] Find rows by 1st letter in MySQL

2002-08-18 Thread Chris Kay 


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