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

2002-08-18 Thread Chris Kay
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 th

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 an

[PHP] Find rows by 1st letter in MySQL

2002-08-18 Thread Tony Harrison
How would I go about selecting rows from a MySQL table where the first letter of a certain field is $letter ? -- - [EMAIL PROTECTED] http://www.cool-palace.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.n