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

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

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