Cheat-Sheet > MCP-DB Cheat-Sheet > Basis-Queries > Query mit WHERE Clause
Entities
Name
Typ
MySQL
TECHNOLOGY
MCP-DB
TECHNOLOGY
db_select
SERVICE
mcp_log
CONFIG
Keywords
SELECTWHERELIMITquerydatabase
Inhalt
Alt (mysql)
Neu (MCP-DB)
mysql -u user -p ki_protokoll \
-e "SELECT * FROM mcp_log
WHERE status = 'success'
LIMIT 10"
db_select(
"SELECT * FROM mcp_log
WHERE status = 'success'
LIMIT 10",
database="ki_protokoll"
)
Clean Content
Alt (mysql)
Neu (MCP-DB)
```
`mysql -u user -p ki_protokoll \
-e "SELECT * FROM mcp_log
WHERE status = 'success'
LIMIT 10"`
```
```
`db_select(
"SELECT * FROM mcp_log
WHERE status = 'success'
LIMIT 10",
database="ki_protokoll"
)`
```