您可以使用Like运算符来处理%通配符。语法如下
select *from yourTableName where yourColumName Like ‘condition%’;
为了理解上述概念,让我们首先创建一个表。查询创建表
mysql> create table SearchDemo -> ( -> Name varchar(100), -> LoginId varchar(100) -> );
使用insert命令在表中插入一些记录。查询如下
mysql> insert into SearchDemo values('John','1_1'); mysql> insert into SearchDemo values('Johnson','1_2'); mysql> insert into SearchDemo values('Carol','2_1'); mysql> insert into SearchDemo values('Bob','11_1'); mysql> insert into SearchDemo values('Sam','11_2'); mysql> insert into SearchDemo values('Mike','21_1');
使用select语句显示表中的所有记录。查询如下
mysql> select *from SearchDemo;
以下是输出
+---------+---------+ | Name | LoginId | +---------+---------+ | John | 1_1 | | Johnson | 1_2 | | Carol | 2_1 | | Bob | 11_1 | | Sam | 11_2 | | Mike | 21_1 | +---------+---------+ 6 rows in set (0.00 sec)
%是一种通配符,代表零个,一个或多个字符。使用%通配符查询如下
mysql> select *from SearchDemo -> where LoginId Like '2%';
以下是输出
+-------+---------+ | Name | LoginId | +-------+---------+ | Carol | 2_1 | | Mike | 21_1 | +-------+---------+ 2 rows in set (0.00 sec)