sql - 编写 SQL 语句，将所有以 'T' 开头的客户名称更改为 'F

Question

编写 SQL 语句以将所有以“T”开头的客户名称更改为“F”我正在尝试解决这个问题。

UPDATE customers
SET first_name ='T'
WHERE First_name like 'F%'

但我必须更改唯一的首字母。

标签： sqloracleoracle11g

Answer 1

还有一个正则表达式选项：

SQL> with customers (first_name) as
  2    (select 'Francisco' from dual union all
  3     select 'fixed'     from dual union all
  4     select 'FFrica'    from dual union all
  5     select 'Marof'     from dual union all
  6     select 'Taurus'    from dual
  7    )
  8  select regexp_replace(first_name, '^F', 'T') result
  9  from customers;

RESULT
-----------------------------------------------------------
Trancisco
fixed
TFrica
Marof
Taurus

SQL>