CamelCase to snake_case in SQL

Asked Jul 24 '15 at 12:50

Active Jul 24 '15 at 14:23

Viewed 154 times

Do you know if it is possible to transform a field content in CamelCase to snake_case ?

Like this:

$ SELECT my_other_field FROM my_table;
+-----------------+
| my_other_field  |
+-----------------+
| ThisIsAnExample |
+-----------------+

$ UPDATE my_table SET my_field = ......(my_other_field);

$ SELECT my_field FROM my_table;
+--------------------+
| my_field           |
+--------------------+
| this_is_an_example |
+--------------------+

edited Jul 24 '15 at 13:16

Thomas Stringer

5,682
3
24
40

asked Jul 24 '15 at 12:50

mykiwi

1,671
1
19
35

1

could you be a little clearer about the use case you imagine. – Nick Bailey Jul 24 '15 at 12:56
string manipulation differs amongst dbms vendors, what dbms is this for? MySQL? – Paul Maxwell Jul 24 '15 at 13:07
SQL? Which vendor/version? – Dave Sexton Jul 24 '15 at 13:07
Which DBMS are you using? Postgres? Oracle? – Jul 24 '15 at 13:07

CamelCase to snake_case in SQL

0 Answers0