Re: Control PhoneNumber Via SQL

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 <tangoward15(at)gmail(dot)com> wrote:

> Did the CASE Statement produce the other columns Sir?
>
> On Wed, May 16, 2018 at 8:53 AM, David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>> On Tuesday, May 15, 2018, tango ward <tangoward15(at)gmail(dot)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.
>>
>
>