Results 1 to 7 of 7
Thread: combining few select queries?
Jan 24, 2005, 18:22 #1
- Join Date
- Jan 2005
- 0 Post(s)
- 0 Thread(s)
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