C
C
CodeInside2015-04-22 16:33:33
MySQL
CodeInside, 2015-04-22 16:33:33

Select index of enum?

There is a table in which 28 fields. And more than 10 enum type fields. It is necessary that on one page the DBMS returns an index, not a field value. Here is an interesting link stackoverflow.com/questions/7369787/how-to-select-... , but even I don’t want to write all 28 fields. You can somehow initially set it so that only the field index is returned and write simply like this: SELECT * FROM `table` ...
?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Slashchinin, 2015-05-22
@CodeInside

SELECT enum_field + 0 FROM ....

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question