---
title: 'Hyperlinks in Tables'
url: 'https://manuals.remository.com/plotalot/tables/hyperlinks-in-tables'
markdown: 'https://manuals.remository.com/plotalot/tables/hyperlinks-in-tables.md'
date: '2026-10-06'
description: 'The sample table shows an example of how to build hyperlinks using the SQL CONCAT function. Here''s the SQL used by the sample table. The %%J_ROOT_URI%% variable is used to provide the current site address. SELECT `title` AS `Article`, DATE(`modified`) AS `Updated`, CONCAT(''<a target="_blank"…'
taxonomy:
  category:
    - docs
---

[](#) [ edit this page](https://github.com/getgrav/grav-skeleton-rtfm-site/blob/develop/pages/07.tables/07.hyperlinks-in-tables/docs.md) 

  [ Plotalot for Joomla ](https://manuals.remository.com/plotalot/)     [ Tables ](https://manuals.remository.com/plotalot/tables)      Hyperlinks in Tables    

# Hyperlinks in Tables

The sample table shows an example of how to build hyperlinks using the SQL CONCAT function. Here's the SQL used by the sample table. The %%J\_ROOT\_URI%% variable is used to provide the current site address.

```
SELECT `title` AS `Article`, DATE(`modified`) AS `Updated`,
    CONCAT('<a target="_blank" href="%%J_ROOT_URI%%/index.php?
    option=com_content&view=article&id=', `id`, '">', `title`, '</a>') AS `Link`
    FROM `#__content`
    ORDER BY `modified` DESC
    LIMIT 10
```

 [ ](https://manuals.remository.com/plotalot/tables/conditional-formatting) [](https://manuals.remository.com/plotalot/tables/table-totals)

---

## Navigation

- Parent: [Tables](https://manuals.remository.com/plotalot/tables.md)
- Previous: [Conditional Formatting](https://manuals.remository.com/plotalot/tables/conditional-formatting.md)
- Next: [Table Totals](https://manuals.remository.com/plotalot/tables/table-totals.md)