From: Jorge Bastos
Date: November 27 2007 4:13pm
Subject: RE: QUERY Structure?
List-Archive: http://lists.mysql.com/win32/18808
Message-Id: <025401c83110$6a972ff0$3fc58fd0$@jorge@decimal.pt>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Something's now right i thing.
Shoudn't it be:

---
SELECT id, LEFT(joketext, 20) FROM joke WHERE jokedate >=3D "2004-04-17" =
AND
joketext LIKE "%chicken%";
---


-----Original Message-----
From: grovesdavid@stripped
[mailto:grovesdavid@stripped]=20
Sent: ter=E7a-feira, 27 de Novembro de 2007 13:59
To: win32@stripped
Subject: QUERY Structure?

Hello,

This is not the QUERY, that is a bit longer than this, but the theory is =
the

same. Can this be done, if so how should it be structured?

SELECT id, LEFT(joketext, 20), WHERE jokedate >=3D "2004-04-17" AND
joketext LIKE "%chicken%",  FROM joke;


Kind Regards

Dave)=20


--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    =
http://lists.mysql.com/win32?unsub=3Dmysql.jorge@stripped