从子字符串分配列中的值

-- 使用 SUBSTRING 和 INSTR 函数提取姓氏和名字
UPDATE users
SET last_name = SUBSTRING(full_name, 1, INSTR(full_name, ' ') - 1),
    first_name = SUBSTRING(full_name, INSTR(full_name, ' ') + 1);

import re

def extract_names(full_name):
    match = re.match(r'(\w+) (\w+)', full_name)
    if match:
        return match.groups()
    return None, None

full_name = "John Doe"
last_name, first_name = extract_names(full_name)
print(f"Last Name: {last_name}, First Name: {first_name}")

import re

def extract_info(text):
    pattern = r'(\d{3})-(\d{2})-(\d{4})'  # 匹配日期格式 YYYY-MM-DD
    match = re.search(pattern, text)
    if match:
        return match.groups()
    return None

text = "Some text with a date 2023-04-30 in it."
year, month, day = extract_info(text)
print(f"Date: {year}-{month}-{day}")

import re

def safe_extract_info(text):
    pattern = r'(\d{3})-(\d{2})-(\d{4})'
    match = re.search(pattern, text)
    if match:
        return match.groups()
    return "Not Found"

text = "Some text without a date."
result = safe_extract_info(text)
print(f"Result: {result}")