List:MySQL on Win32« Previous MessageNext Message »
From:Muthukumar Selvarasu Date:November 27 2007 8:29pm
Subject:RE: QUERY Structure?
View as plain text  
Hi Dave,

Well, I think you posted partial query here.

here the syntax to follow simply or you can check the sql manual.

select fields1, fields2, .... fieldsn from table_name  where condition
group by field  order by field limit n,n1

this is standard syntax for simple select, but in mysql 5 select syntax bit
change when you doing multiple table join.

Thanks
Muthukumar Selvarasu,
Project Manager,
Webmaster Ltd.

-----Original Message-----
From: grovesdavid@stripped
[mailto:grovesdavid@stripped] 
Sent: Wednesday, November 28, 2007 1:59 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) 


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=1


Thread
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