---
title: "How to use SQL to find pages"
canonical: "https://support.appfire.com/space/SUPPORT/89146777/How%20to%20use%20SQL%20to%20find%20pages"
format: markdown
---
# Description

This may be appropriate if you have specific requirements and conditions. Otherwise we recommend using the techniques from [How to find Confluence pages and then do something](https://appfire.atlassian.net/wiki/spaces/SUPPORT/pages/89147235)

1. You are familiar with SQL
2. Confluence Server and you have access to the Confluence database
3. You want to do exact content search and have a large number of pages which would prevent you from using the [Search Content](https://bobswift.atlassian.net/wiki/spaces/CSOAP/pages/32571427/How+to+Find+Confluence+Pages+and+Then+Do+Something#HowtoFindConfluencePagesandThenDoSomething-SearchContent) approach because it would take too long.

# Steps

1. Construct a SQL query that selects the pages you are interested in. Test against your database.
3. Figure out the **runFromSql** parameters for accessing your database.
4. Put it all together in a single command: