View Single Post
  #21 (permalink)  
Old 08-03-2007, 10:59 AM
Murali Murali is offline
D-Web Master
 
Join Date: Feb 2007
Location: India-Chennai.
Posts: 386
Murali is on a distinguished road
Send a message via AIM to Murali
Default Re: Use on group_concat

Quote:
Originally Posted by Murali View Post
Hi,

Have u noticed one thing,

Code:
SELECT GROUP_CONCAT(Field_name) FROM table_name LIMIT 0,10;
But didn't get the expected result?
Ya may be this is the reason,using this query
SELECT GROUP_CONCAT(Field_name) FROM table_name LIMIT 1,10;

i didn't get any output from the quey, it shows that the GROUP_CONCAT() Function captures the values from the field and then applies the LIMIT CLAUSE.

This may be reason....
__________________
-Murali..
Reply With Quote
Sponsored Links