The easiest way is using the data explorer plugin.
You can create a SQL query such as:
SELECT raw, cooked from posts
where raw like '%text from the post%'
And it returns these fields’ content:
It’s a great tool to explore data (
) and try to debug stuff sometimes.