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
