QUERY Structure? 2007-11-27 - By Jorge Bastos
Back
Something's now right i thing.
Shoudn't it be:
---
SELECT id, LEFT(joketext, 20) FROM joke WHERE jokedate >= "2004-04-17" AND
joketext LIKE "%chicken%";
---
-- --Original Message-- --
From: grovesdavid@(protected)
[mailto:grovesdavid@(protected)]
Sent: ter?a-feira, 27 de Novembro de 2007 13:59
To: win32@(protected)
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 >= "2004-04-17" AND
joketext LIKE "%chicken%", FROM joke;
Kind Regards
Dave)
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql.jorge@(protected)
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
|
|
