How to do ORDER BY and LIMIT to part of a select statement?

[Zac5]

I want to perform 'order by' and 'limit' to part of my select statement, that is, only the part that meets the first condition, so i want to achieve following:

select * from page where (type=6 order by edate limit 1) or (date > (UNIX_TIMESTAMP-8400));

However this is not accepted - any suggestions please??

Many thanks!

 

[r937]

( select * from page
where type=6
order by edate limit 1 )
union all
( select * from page
where date > (UNIX_TIMESTAMP-8400)

caution: untested


rudy

http://r937.com/

SQL Consulting

 

[Zac5]

Didnt work - I dont think the version of MySQL I have supports UNION, I get an error.

 

[r937]

well, you did not say which version you are on, so i felt it was only fair for me to use syntax from the current version

because you want only one of X but all of Y, you will have to use two queries

rudy

http://r937.com/

SQL Consulting

 

[Zac5]

You are right. I'm sorry i didnt mention my version of mysql. I will use an alternative approach with the help of perl. Many thanks for your help.

 

[tshot]

Hi Zac5

You can create a query handle using syntax what MySql allows. And if your version does not allow UNION then you can try for the following suggested by r937 in another thread

http://codewalkers.com/tutorials/33/1.html

----------------
ur feedback is a very welcome desire