Need DB query to perform search in confluence pages for Jira links

[Raja rajeswari Gurram 1995]

Hi Team,

Kindly help me to find confluence-SQL DB query, to perform search for Jira links having single project key in entire confluence pages
and DB query to replace what ever old URL find out using search query with new jira URL

Thanks in advance

Rajeswari

[Nic Brough -Adaptavist-]

There isn't any SQL that can find this - in many cases, the Jira links are not in the database, they're worked out when needed for a display.

I would strongly recommend that you stop looking at the database.  You should never update an Atlassian database, it's the wrong way to achieve whatever you think you want to do.