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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

May 2026 Splunk Expert Sessions: Security & Observability

Level Up Your Operations: May 2026 Splunk Expert Sessions Whether you are refining your security posture or ...

Network to App: Observability Unlocked [May & June Series]

In today’s digital landscape, your environment is no longer confined to the data center. It spans complex ...

SPL2 Deep Dives, AppDynamics Integrations, SAML Made Simple and Much More on Splunk ...

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...