如何使用MySQL LIKE子句获取以“ Joh”开头的多个值
让我们首先创建一个表-
mysql> create table DemoTable ( Name varchar(40) );
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable values('John'); mysql> insert into DemoTable values('Sam'); mysql> insert into DemoTable values('Mike'); mysql> insert into DemoTable values('Ethan'); mysql> insert into DemoTable values('Johnson'); mysql> insert into DemoTable values('Bob');
使用select语句显示表中的所有记录-
mysql> select *from DemoTable;
这将产生以下输出-
+---------+ | Name | +---------+ | John | | Sam | | Mike | | Ethan | | Johnson | | Bob | +---------+ 6 rows in set (0.00 sec)
以下是获取以“Joh”开头的多个值的查询-
mysql> select *from( select Name as myValue from DemoTable union select Name from DemoTable )tbl where myValue like 'Joh%';
这将产生以下输出-
+---------+ | myValue | +---------+ | John | | Johnson | +---------+ 2 rows in set (0.00 sec)