group by?

Pavel Zagrebelin 13.02.2004 11:08

^connect[$SQL.connect-string]{
   $search_result[^table::sql{
      SELECT
         max(id) as id, 
         head, 
         body,
         count(*) as cnt
      FROM content 
      WHERE body LIKE '%$form:search%'
      GROUP BY head
   }]