searching for page content

[Michael Bond]

I'm not able to find specific page content in my searches. I'd like to find table entries, words or phrases in paragraphs, etc. Is it possible to search for that type of page content?

[Rodrigo Girardi Adami]

Hi Michael,

In addition to Davin answer, you can also search for Confluence pages having an specific word by running a select query in the BODYCONTENT table like the example below:

select c.title from content c
join bodycontent b on b.contentid = c.contentid
where b.body like '%<word_to_search>%';

Just replace the <word_to_search> from the query above and run.

Cheers,

Rodrigo

[Davin Studer]

I you want to search for a specific phrase then surround it by quotes in the search field. Also, check our the Search syntax page. It has some good info for how to effectively search Confluence.

https://confluence.atlassian.com/display/DOC/Confluence+Search+Syntax