in reply to Re: returning first row of SQL queryin thread returning first row of SQL query
LIMIT 1 works perfectly, sorry I hadn't thought of solving the problem with SQL rather than through perl!