I have a table with about 100 column with different column name. It is
difficult to remember all the field
names. But I know the last few columns are very important for query and
used frequently.
For example:
Table with fields weight_42(double),width_43(double),height_44(double)
where the fields(42), field(43) and field(44) respectively
mysql> select * from data_base where weight_42 < 45.23 or width_43 <
43.23 or height_44 < 43.23 ;
can i query using :
mysql> select * from data_base where field(43) < 45.23 and field(44) <
45.23 and field(45) < 45.23;
or to use in java:
float j=43.25;
for(i=43;i<=45;i++)
{
S1=select * from data_base where field(" + i +") < " + j;
QUERY,
RESULT SET
etc.,
}
Thank you
M.Karthikeyan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
