Forum Discussion

testBench's avatar
testBench
New Member
2 years ago

JDBC Request/Query for value located within data BLOB

I am attempting to execute the following query within a ReadyAPI JDBC request  SELECT *  FROM consumer WHERE consumer.payload LIKE '%name%' The issue is that ReadyAPI treats the '%' as part of th...
Scripting
nmrao's avatar
nmrao
Community Hero
2 years ago

Can you please check if below helps?

SELECT * 
FROM consumer
WHERE consumer.payload LIKE '%%name%%'

Also see if you can use property expansion