This has to be a first! I've been watching this forum for some years and
have never seen John Bonnet give a wrong answer, but this time he
missed. You have more problems with your query than he outlines. Still,
"full text index may be more efficient."
The previous three answers are correct. I strongly suggest you RTM.
Randy Clamons
Systems Programming
randy@stripped
Bonnett, John wrote:
> 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)
>
>
>
>
