Get Column names from table

[IWeb]

Hello!

I am using java and mysql 4.0.x. For getting the column names of a table I use:

SHOW COLUMNS FROM _TABLENAME_

.

Now I just want to get back columns with only numeric values (float, double, integer). How could I achive this?

Thanks,

[LordShryku]

Don't know that there is a pure SQL solution to this, in which case, you should probably ask in a Java forum.

There are php functions that could handle this though...

[IWeb]

thanks for answering.
i justed implemented it with a simple substring checking and it works great. there might be better solutions but it also works this way 😉.