在MySQL中显示名字和姓氏以相同字母开头的记录
要检查名字和姓氏的第一个字母，您需要使用LEFT()。
让我们首先创建一个表-
mysql> create table DemoTable789 ( FirstName varchar(100), LastName varchar(100) );
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable789 values('Adam','Smith');
mysql> insert into DemoTable789 values('Tom','Taylor');
mysql> insert into DemoTable789 values('Bob','Brown');
mysql> insert into DemoTable789 values('David','Miller');使用select语句显示表中的所有记录-
mysql> select *from DemoTable789;
这将产生以下输出-
+-----------+----------+ | FirstName | LastName | +-----------+----------+ | Adam | Smith | | Tom | Taylor | | Bob | Brown | | David | Miller | +-----------+----------+ 4 rows in set (0.00 sec)
显示在MySQL中姓和名以相同字母开头的记录-
mysql> select *from DemoTable789 where upper(left(FirstName,1))=upper(left(LastName,1));
这将产生以下输出-
+-----------+----------+ | FirstName | LastName | +-----------+----------+ | Tom | Taylor | | Bob | Brown | +-----------+----------+ 2 rows in set (0.00 sec)