Splunk Search

How to include quote within LIKE keyword in Dbxquery?

LearningGuy
Motivator

how to include quote within LIKE keyword in Dbxquery?
For example:    There are 10k people in the DB and I would like to query only those who contains number:123
The problem is the content has quote ".   Note I cannot filter only 123 because it will also match another record.  
name = person1
content = {"description:"test",number":123,"status":"good"}

| dbxquery connection = visibility query = "select name, content from TestDB where content like '%number":123%'

Thanks

Labels (3)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Have you tried escaping the quotation mark?  Just a guess.

| dbxquery connection = visibility query = "select name, content from TestDB where content like '%number\":123%'"

 

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...