sql, database query -

could tell me how select particular column if dont know schema of table .like if want values in second column of database table without knowing column name. there way that?

not sure wanted do. , sincerely expect don't you're doing. if jsut wanted know how play technicality. here example it. there may better ways.

mysql> desc test; +-------+--------------+------+-----+---------+-------+ | field | type         | null | key | default | | +-------+--------------+------+-----+---------+-------+ | id    | int(11)      | yes  |     | null    |       | | name  | varchar(100) | yes  |     | null    |       | +-------+--------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)  mysql> select * test; +------+-------+ | id   | name  | +------+-------+ |    1 | name1 | |    2 | name2 | |    3 | name3 | |    4 | name4 | +------+-------+ 4 rows in set (0.00 sec)  mysql> select @colid:=column_name information_schema.columns table_schema='test' , table_name='test' , ordinal_position=2; +---------------------+ | @colid:=column_name | +---------------------+ | name                | +---------------------+ 1 row in set (0.01 sec)  mysql> set @sqlstr:=concat('select ', @colid, ' test'); query ok, 0 rows affected (0.00 sec)  mysql> prepare sttmt @sqlstr; query ok, 0 rows affected (0.00 sec) statement prepared  mysql> execute sttmt; +-------+ | name  | +-------+ | name1 | | name2 | | name3 | | name4 | +-------+ 4 rows in set (0.00 sec) 

refer last example here http://dev.mysql.com/doc/refman/5.0/en/user-variables.html

---

by way, google gives first link perfect solution. select statement column number instead of column names