mysql: options for row designations?

[tiggy]

Is there a means by which I can refer to a row numerically rather by name, e.g.:

select * from table order by table->row(2);

Something like that, you get the idea...

I'm trying to write some general functions that would benefit from this capability if it exists.

Thanks in advance,
Al

[toma42]

make sure you have a primary key column that is an integer or long (depending on your database) then order by that.

select * from table order by table_key

[Bunkermaster]

that is the kind of thing we do with precise queries.

[tiggy]

Sorry, my question was poorly worded. What I'm looking for is a way of designating a field in a query numerically rather than the name of the field, e.g.

Instead of:

select customerid from business

something like:

select business->column[0] from business

i.e., select the 1st column from the business table

I know this is possible in Sybase via a different syntax - just wondering if the same kind of thing is possible in mysql.

Thanks,
Al

[Bunkermaster]

what you could do is buyild an array containing the name of the fiels of the table first and then use this array to build your query...