MySQL 如何在列中左侧和中间的字符串中转义 ‘%’ 字符

首先，我们创建一个表 –

mysql> create table DemoTable629 (StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY,StudentSubject text);
Query OK, 0 rows affected (0.77 sec)

使用插入命令将一些记录插入表中 –

mysql> insert into DemoTable629(StudentSubject) values('MySQL%');
Query OK, 1 row affected (0.15 sec)
mysql> insert into DemoTable629(StudentSubject) values('Spring%Hibernate');
Query OK, 1 row affected (0.16 sec)
mysql> insert into DemoTable629(StudentSubject) values('%Java');
Query OK, 1 row affected (0.21 sec)

使用查询语句显示表中的所有记录 –

mysql> select *from DemoTable629;

这将产生以下输出 –

+-----------+------------------+
| StudentId | StudentSubject   |
+-----------+------------------+
|         1 | MySQL%           |
|         2 | Spring%Hibernate |
|         3 | %Java            |
+-----------+------------------+
3 rows in set (0.00 sec)

以下是转义 ‘%’ 字符的查询语句 –

mysql> select *from DemoTable629
   where StudentSubject like '%\%';

这将产生以下输出 –

+-----------+----------------+
| StudentId | StudentSubject |
+-----------+----------------+
|         1 | MySQL%         |
+-----------+----------------+
1 row in set (0.00 sec)

阅读更多：MySQL 教程