on 7/14/05 3:54 PM, Sebastian at [EMAIL PROTECTED] wrote: > i have a text field column and i want to select the rows based on the > first letter in this column, eg:
SELECT field from table WHERE field LIKE 'M%' -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]