Posted by Richard Lynch on 04/20/05 05:28

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

• Next in forum: Re: [PHP] PHP script problem (with MySQL)
• Prev in forum: Re: [PHP] script
• Thread view: Re: [PHP] PHP script problem (with MySQL)

[Reply to this message]