Okay, I figured it out. cur_t.execute(""" SELECT CASE WHEN mobilenumber ~'^0[1-9]' THEN regexp_replace(mobilenumber, '0', '+63') ELSE mobilenumber END FROM studeprofile ORDER BY lastname """)
In my previous SELECT statement, I picked the mobilenumber before running a CASE statement to it instead of jumping directly to CASE statement after SELECT. On Wed, May 16, 2018 at 8:59 AM, tango ward <tangowar...@gmail.com> wrote: > Did the CASE Statement produce the other columns Sir? > > On Wed, May 16, 2018 at 8:53 AM, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Tuesday, May 15, 2018, tango ward <tangowar...@gmail.com> wrote: >>> >>> >>> I can access the index 1 of the output list to get the +639078638001. I >>> think this has been explained already by Sir Adrian in my previous question >>> about the about being shown as list. I'll review that. >>> >> >> Last time you had multiple rows...this time you have multiple columns... >> >> David J. >> > >