An hour ago run into a problem with mysql.
I have a table with few fields, some of them are SET type like
fruit SET('apple', 'lemon', 'banana')

How can I get 'apple', 'lemon', 'banana' from SQL query knowing name of field?
Will it be fine to use such sql query in production script?

Thanks in advance.

Never tried it, but maybe with http://www.php.net/manual/en/functio...field-type.php
or, as the comments suggest:

 $result = mysql_query("SHOW FIELDS FROM table.db");

I also don't know much about it but i feel that the above code given by tripy should work.

The query given by tripy will give you all the fields.

Since you know the field name, you can use LIKE to limit it to that field only.

PHP Code:

 $result = mysql_query("SHOW FIELDS FROM table.db LIKE '%pattern%' "); 


actually the OP is trying to get the possible values for the SET (or enum)

SHOW COLUMNS FROM table LIKE 'ColumnName' ;

and in the Type column returned from that query you should find "set('val1','val2',val3')

try:

dim variable as string

variable=recordname.fields!Value

If you were using SQL Server, you could put the cursor in the name of the table and hit ALT + F1.