MySQL Forums
Forum List  »  MySQL Query Browser

Re: How to write the following query ?
Posted by: Chad Bourque
Date: May 14, 2010 09:22AM

Amit,

If the numbers aren't sequential, you'll be out of luck with this query. If they are sequential, you can convert it to a number within the query. If they aren't, you'd likely need to create another table that listed the addresses in the order you want and had a sequential number associated with them. Or add a sequential number column to your main table.

HTH,
Chad

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.