> For the complete documentation index, see [llms.txt](https://hacking-notes.jord4n.pro/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://hacking-notes.jord4n.pro/zh/web/sql-injection/sql-injection-in-where-clause.md).

# WHERE 子句中的 SQL 注入

### WHERE 子句中的 SQL 注入漏洞，允许检索隐藏数据

* **背景 / 漏洞：** 类别筛选器存在 SQL 注入漏洞。服务器上执行的典型请求：/ `SELECT * FROM products WHERE category = 'Gifts' AND released = 1`
* \*\*攻击目标（实验室）：\*\*强制显示一个或多个未发布的产品（`released = 0`).
* **易受攻击的参数：** `category` （产品筛选器）。
* **概念验证（提供的 payload）：**

```sql
test' or category='Lifestyle' and released=0-- -
```

* 简要解释：该 payload 修改了 WHERE 条件，以包含以下条目的记录： `category='Lifestyle' AND released=0`，绕过 `released = 1` 约束。
* **预期结果：** 页面返回并显示对应于 `released = 0` （未发布的产品）。
* **影响：** 隐藏元素泄露、潜在敏感数据外泄、规避业务逻辑（非面向公众）。


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://hacking-notes.jord4n.pro/zh/web/sql-injection/sql-injection-in-where-clause.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.