MySQL查询以获取不包含空格的字段值？
为此使用“不喜欢”。让我们首先创建一个表-
mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentFullName varchar(40) );
使用插入命令在表中插入记录-
mysql> insert into DemoTable(StudentFullName) values('JohnSmith');
mysql> insert into DemoTable(StudentFullName) values('John Doe');
mysql> insert into DemoTable(StudentFullName) values('Adam Smith');
mysql> insert into DemoTable(StudentFullName) values('CarolTaylor');使用select语句显示表中的所有记录-
mysql> select * from DemoTable;
这将产生以下输出-
+----+-----------------+ | Id | StudentFullName | +----+-----------------+ | 1 | JohnSmith | | 2 | John Doe | | 3 | Adam Smith | | 4 | CarolTaylor | +----+-----------------+ 4 rows in set (0.00 sec)
以下是获取不包含空格的字段值的查询-
mysql> select *from DemoTable where StudentFullName NOT LIKE '% %';
这将产生以下输出-
+----+-----------------+ | Id | StudentFullName | +----+-----------------+ | 1 | JohnSmith | | 4 | CarolTaylor | +----+-----------------+ 2 rows in set (0.18 sec)