How to return enum column values as integer in PHP

Question

I can easily insert into database for enum columns or update them via enum index... For example I have an enum column ('first','second','third') => (0,1,2)! When I want to insert first for column , I will pass the 0 to insert and like this for other values.... How can I get the values now? For example

SELECT * FROM table WHERE primary_id = 1

Now I want to get the enum column value index of this row. if the enum column value is 'second', how can I get index 1?

ReynierPM · Accepted Answer · 2019-08-15 18:46:36Z

0

You should not be using numbers as enumeration value as enum type states in doc. The index of the enum item is returned, not the enum value itself.

Also check here ISSUE: Mysql converting Enum to Int

answered Aug 15, 2019 at 18:46

ReynierPM

18.7k57 gold badges207 silver badges392 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to return enum column values as integer in PHP

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related