---
title: "How to hyperlink the SQL macro results"
canonical: "https://support.appfire.com/space/SUPPORT/89140808/How%20to%20hyperlink%20the%20SQL%20macro%20results"
format: markdown
---
This article explains how to convert results generated by the SQL for Confluence app into hyperlinks that navigate you to intended pages. 

## Instructions

Consider an example where you are fetching a list of users from MySql database.

1. Fetch the list of users from the database using the following SQL query.
2. To convert the result to a clickable hyperlink, use the SQL** CONCAT** function in a SQL query and make output format as **wiki** in the SQL macro**.**
3. The above query adds user profile links as hyperlinks to the users list as shown in:
  
4. Click any of the hyperlinks to navigate to the respective user profile page to view the user deatils.