Re: PHP&MySQL left/substring etc problem
| From: | Andrés G. Montañez | Date: | Tue, 19 Apr 2005 06:35:57 +0000 |
| Subject: | Re: PHP&MySQL left/substring etc problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39224@lists.php.net to get a copy of this message | ||
> But when I tried, "select left (loc1,3) from openart_table where......"
Try without the space between 'left' and '(',
I mean... LEFT(loc1, 3)
where loc1 is the name of the column,
and 3 the characters you want to show.
--
Atte, Andrés G. Montañez
Técnico en Redes y Telecomunicaciones
Montevideo - Uruguay