combining few select queries?
hi, i searched a bit about this but can't seem to find a good answer
anyways what i am trying to do is combine about 3 select queries that select one line each like first and last
atm i got
SELECT title , time FROM products WHERE title LIKE '%-$sets' ORDER BY `time` ASC LIMIT 0, 1
SELECT title , time FROM products WHERE title LIKE '%-$sets' ORDER BY `time` DESC LIMIT 0, 1
basically my quastion is there a way to combine them both ? it would save me a lot of work on tcl code part because i use something like this along about 5 separate scripts so it adds up
any ideas/help appreciated or if you have any other performance hints i could use also appreciated