SQL 选择用字符串替换整数

使用SQL进行字符串替换整数操作

sql
SELECT
  column1,
  column2,
  CAST(column3 AS VARCHAR(255)) AS converted_column
FROM
  your_table;

sql
SELECT
  column1,
  column2,
  CASE
    WHEN column3 < 0 THEN 'Negative'
    WHEN column3 = 0 THEN 'Zero'
    ELSE CAST(column3 AS VARCHAR(255))
  END AS replaced_column
FROM
  your_table;

sql
CREATE TABLE length_table (
  id INT PRIMARY KEY,
  object_name VARCHAR(50),
  length_value INT
);
INSERT INTO length_table VALUES
  (1, 'Table', 150),
  (2, 'Chair', 80),
  (3, 'Bookshelf', 200);

sql
SELECT
  id,
  object_name,
  CASE
    WHEN length_value >= 100 THEN CONCAT(length_value, ' cm')
    ELSE CONCAT(length_value, ' inches')
  END AS formatted_length
FROM
  length_table;