Yes that should be OK. You have a superfluous comma just before FROM
though.
If you are doing a lot of this a full text index may be more efficient.
John Bonnett
-----Original Message-----
From: grovesdavid@stripped
[mailto:grovesdavid@stripped]
Sent: Wednesday, 28 November 2007 12:29 AM
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 >= "2004-04-17" AND
joketext LIKE "%chicken%", FROM joke;
Kind Regards
Dave)
