[Connective issues may make this a duplicate post. Sorry.] On Tue, April 19, 2005 6:25 pm, Sugimoto said: > What I do like to do is to get first 3 letters from "loc1" column from openart_table (MySQL).
select substring(loc1, 1, 3) as THREE_LETTER_CODE, * from openart_table ... -- Like Music? http://l-i-e.com/artists.htm -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php