mysql__CASE WHEN进行字符串替换处理_MySQL
bitsCN.com
mysql__CASE WHEN进行字符串替换处理
使用CASE WHEN进行字符串替换处理
03 mysql> select * from sales;04 +-----+------------+--------+--------+--------+------+------------+05 | num | name | winter | spring | summer | fall | category |06 +-----+------------+--------+--------+--------+------+------------+07 | 1 | Java | 1067 | 200 | 150 | 267 | Holiday |08 | 2 | C | 970 | 770 | 531 | 486 | Profession |09 | 3 | JavaScript | 53 | 13 | 21 | 856 | Literary |10 | 4 | SQL | 782 | 357 | 168 | 250 | Profession |11 | 5 | Oracle | 589 | 795 | 367 | 284 | Holiday |12 | 6 | MySQL | 953 | 582 | 336 | 489 | Literary |13 | 7 | Cplus | 752 | 657 | 259 | 478 | Literary |14 | 8 | Python | 67 | 23 | 83 | 543 | Holiday |15 | 9 | PHP | 673 | 48 | 625 | 52 | Profession |16 +-----+------------+--------+--------+--------+------+------------+17 9 rows in set (0.01 sec)18 19 mysql> SELECT name AS Name,20 -> CASE category21 -> WHEN "Holiday" THEN "Seasonal"//把sales表字段category中Holiday值替换为seasonal22 -> WHEN "Profession" THEN "Bi_annual"23 -> WHEN "Literary" THEN "Random" END AS "Pattern"//查询的结果命名为一个新的字段为pattern24 -> FROM sales;25 +------------+-----------+26 | Name | Pattern |27 +------------+-----------+28 | Java | Seasonal |29 | C | Bi_annual |30 | JavaScript | Random |31 | SQL | Bi_annual |32 | Oracle | Seasonal |33 | MySQL | Random |34 | Cplus | Random |35 | Python | Seasonal |36 | PHP | Bi_annual |37 +------------+-----------+38 9 rows in set (0.00 sec)39 40 41 */42 Drop table sales;43 44 CREATE TABLE sales(45 num MEDIUMINT NOT NULL AUTO_INCREMENT,46 name CHAR(20),47 winter INT,48 spring INT,49 summer INT,50 fall INT,51 category CHAR(13),52 primary key(num)53 )type=MyISAM;54 55 56 insert into sales value(1, 'Java', 1067 , 200, 150, 267,'Holiday');57 insert into sales value(2, 'C',970,770,531,486,'Profession');58 insert into sales value(3, 'JavaScript',53,13,21,856,'Literary');59 insert into sales value(4, 'SQL',782,357,168,250,'Profession');60 insert into sales value(5, 'Oracle',589,795,367,284,'Holiday');61 insert into sales value(6, 'MySQL',953,582,336,489,'Literary');62 insert into sales value(7, 'Cplus',752,657,259,478,'Literary');63 insert into sales value(8, 'Python',67,23,83,543,'Holiday');64 insert into sales value(9, 'PHP',673,48,625,52,'Profession');65 66 select * from sales;67 68 69 SELECT name AS Name,70 CASE category71 WHEN "Holiday" THEN "Seasonal"72 WHEN "Profession" THEN "Bi_annual"73 WHEN "Literary" THEN "Random" END AS "Pattern"74 FROM sales;SELECT num,name AS Name, case categorywhen "Holiday" then "1111" #把categroy字段中的Holiday替换为1111WHEN "Profession" THEN "2222" #把categroy字段中的Holiday替换为2222WHEN "Literary" THEN "3333" #把categroy字段中的Holiday替换为3333END AS "从新命名标题" #把categroy重新命名为'从新命名标题'FROM sales;
bitsCN.com
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1389
52
How to determine whether a Golang string ends with a specified character
Mar 12, 2024 pm 04:48 PM
Title: How to determine whether a string ends with a specific character in Golang. In the Go language, sometimes we need to determine whether a string ends with a specific character. This is very common when processing strings. This article will introduce how to use the Go language to implement this function, and provide code examples for your reference. First, let's take a look at how to determine whether a string ends with a specified character in Golang. The characters in a string in Golang can be obtained through indexing, and the length of the string can be
Detailed explanation of the method of converting int type to string in PHP
Mar 26, 2024 am 11:45 AM
Detailed explanation of the method of converting int type to string in PHP In PHP development, we often encounter the need to convert int type to string type. This conversion can be achieved in a variety of ways. This article will introduce several common methods in detail, with specific code examples to help readers better understand. 1. Use PHP’s built-in function strval(). PHP provides a built-in function strval() that can convert variables of different types into string types. When we need to convert int type to string type,
How to repeat a string in python_python repeating string tutorial
Apr 02, 2024 pm 03:58 PM
1. First open pycharm and enter the pycharm homepage. 2. Then create a new python script, right-click - click new - click pythonfile. 3. Enter a string, code: s="-". 4. Then you need to repeat the symbols in the string 20 times, code: s1=s*20. 5. Enter the print output code, code: print(s1). 6. Finally run the script and you will see our return value at the bottom: - repeated 20 times.
How to intercept a string in Go language
Mar 13, 2024 am 08:33 AM
Go language is a powerful and flexible programming language that provides rich string processing functions, including string interception. In the Go language, we can use slices to intercept strings. Next, we will introduce in detail how to intercept strings in Go language, with specific code examples. 1. Use slicing to intercept a string. In the Go language, you can use slicing expressions to intercept a part of a string. The syntax of slice expression is as follows: slice:=str[start:end]where, s
How to check if a string starts with a specific character in Golang?
Mar 12, 2024 pm 09:42 PM
How to check if a string starts with a specific character in Golang? When programming in Golang, you often encounter situations where you need to check whether a string begins with a specific character. To meet this requirement, we can use the functions provided by the strings package in Golang to achieve this. Next, we will introduce in detail how to use Golang to check whether a string starts with a specific character, with specific code examples. In Golang, we can use HasPrefix from the strings package
How to solve the problem of Chinese garbled characters when converting hexadecimal to string in PHP
Mar 04, 2024 am 09:36 AM
Methods to solve Chinese garbled characters when converting hexadecimal strings in PHP. In PHP programming, sometimes we encounter situations where we need to convert strings represented by hexadecimal into normal Chinese characters. However, in the process of this conversion, sometimes you will encounter the problem of Chinese garbled characters. This article will provide you with a method to solve the problem of Chinese garbled characters when converting hexadecimal to string in PHP, and give specific code examples. Use the hex2bin() function for hexadecimal conversion. PHP’s built-in hex2bin() function can convert 1
PHP String Matching Tips: Avoid Ambiguous Included Expressions
Feb 29, 2024 am 08:06 AM
PHP String Matching Tips: Avoid Ambiguous Included Expressions In PHP development, string matching is a common task, usually used to find specific text content or to verify the format of input. However, sometimes we need to avoid using ambiguous inclusion expressions to ensure match accuracy. This article will introduce some techniques to avoid ambiguous inclusion expressions when doing string matching in PHP, and provide specific code examples. Use preg_match() function for exact matching In PHP, you can use preg_mat
PHP string manipulation: a practical way to effectively remove spaces
Mar 24, 2024 am 11:45 AM
PHP String Operation: A Practical Method to Effectively Remove Spaces In PHP development, you often encounter situations where you need to remove spaces from a string. Removing spaces can make the string cleaner and facilitate subsequent data processing and display. This article will introduce several effective and practical methods for removing spaces, and attach specific code examples. Method 1: Use the PHP built-in function trim(). The PHP built-in function trim() can remove spaces at both ends of the string (including spaces, tabs, newlines, etc.). It is very convenient and easy to use.
