如果字符串小于特定长度，则在MySQL中显示子字符串，如果大于则显示定制消息？
为此，您可以使用substring()MySQL中的函数。对于条件，请使用MySQLCASE语句。让我们首先创建一个-
mysql> create table DemoTable1402 -> ( -> EmployeeName varchar(40) -> );
使用insert在表中插入一些记录-
mysql> insert into DemoTable1402 values('Adam Smith');
mysql> insert into DemoTable1402 values('Chris Brown');
mysql> insert into DemoTable1402 values('David Miller');
mysql> insert into DemoTable1402 values('Carol Taylor');使用选择显示表中的所有记录-
mysql> select * from DemoTable1402;
这将产生以下输出-
+--------------+ | EmployeeName | +--------------+ | Adam Smith | | Chris Brown | | David Miller | | Carol Taylor | +--------------+ 4 rows in set (0.00 sec)
这是查询，如果字符串小于特定长度，则在MySQL中显示子字符串；如果大于，则显示自定义消息-
mysql> select *, case when char_length(EmployeeName) <=11 then substring(EmployeeName,1,5) -> else 'EmployeeName is greater than 11' -> end as Result -> from DemoTable1402;
这将产生以下输出-
+--------------+---------------------------------+ | EmployeeName | Result | +--------------+---------------------------------+ | Adam Smith | Adam | | Chris Brown | Chris | | David Miller | EmployeeName is greater than 11 | | Carol Taylor | EmployeeName is greater than 11 | +--------------+---------------------------------+ 4 rows in set (0.04 sec)
热门推荐
10 姐姐女儿结婚祝福语简短
11 形容新年的祝福语简短
12 周末祝福语简短的英语
13 给侄子祝福语简短精辟
14 祝福语简短古诗词
15 祝福语写给自己的简短
16 对女友的简短祝福语
17 祝妹妹毕业祝福语简短
18 老人过大寿祝福语简短