让我们首先创建一个表-create table DemoTable
-> (
-> EmployeeName varchar(100)
-> );
使用插入命令在表中插入一些记录-insert into DemoTable values('Adam Smith');
insert into DemoTable values('Carol Taylor');
insert into DemoTable values('David Miller');
insert into DemoTable values('Chris Evan');
使用select语句显示表中的所有记录-select *from DemoTable;
输出结果
这将产生以下输出-+--------------+
| EmployeeName |
+--------------+
| Adam Smith |
| Carol Taylor |
| David Miller |
| Chris Evan |
+--------------+
4 rows in set (0.00 sec)
以下是要在列的后5个字符内搜索的查询-select *from DemoTable where Right(EmployeeName, InStr(EmployeeName, ' ' )) LIKE 'Mille%';
输出结果
这将产生以下输出-+--------------+
| EmployeeName |
+--------------+
| David Miller |
+--------------+
1 row in set (0.00 sec)