remove first row from query

[dadamssg87]

I have a query that brings up several rows. How do i get it to remove the first row? I know you can LIMIT how many results get brought up but i just want to drop the first one.

 

$query = "Select * FROM Exceptions WHERE hash = '$hash' ORDER BY created DESC";

[dadamssg87]

thought of a quick easy fix...

 

<?php
$num = 0;
foreach($query as $row)
{
   $num++;
   if($num > 1)
   {
      //display all but first row
    }
}
?>

[Pikachu2000]

This is much better than selecting the entire table to get one record's contents:

SELECT * FROM Exceptions WHERE hash = '$hash' ORDER BY created DESC LIMIT 1, 1