List:MySQL on Win32« Previous MessageNext Message »
From:John Bonnett Date:November 27 2007 9:55pm
Subject:RE: QUERY Structure?
View as plain text  
Yes that should be OK. You have a superfluous comma just before FROM

If you are doing a lot of this a full text index may be more efficient.

John Bonnett 

-----Original Message-----
From: grovesdavid@stripped
Sent: Wednesday, 28 November 2007 12:29 AM
To: win32@stripped
Subject: QUERY Structure?


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


QUERY Structure?grovesdavid27 Nov
  • RE: QUERY Structure?Jorge Bastos27 Nov
  • Re: QUERY Structure?Todd Farmer27 Nov
  • RE: QUERY Structure?Muthukumar Selvarasu27 Nov
  • RE: QUERY Structure?John Bonnett27 Nov
    • Re: QUERY Structure?Randy Clamons27 Nov