---
title: "How to Show WordPress Database Entries in an Elementor Table?"
url: https://theplusaddons.com/docs/show-wordpress-database-entries-in-an-elementor-table/
date: 2025-10-15
modified: 2026-04-09
author: "Aditya Sharma"
description: "Sometimes, you may have useful data stored in your website’s database, like product details, event registrations or other information, and you want to show it directly to your visitors. By..."
image: https://theplusaddons.com/wp-content/uploads/2025/10/How-to-Show-WordPress-Database-Entries-in-an-Elementor-Table-1024x538.jpg
word_count: 368
---

# How to Show WordPress Database Entries in an Elementor Table?

## Key Takeaways

- The Plus Addons for Elementor Table widget displays database entries using a SQL query.
- Users can show the first 10 published blog posts by executing the SQL query: SELECT ID, post_title, post_date FROM wp_posts WHERE post_status = 'publish' AND post_type = 'post' LIMIT 10.
- The Refresh Time dropdown allows users to select how often new data is pulled from the database table.

Sometimes, you may have useful data stored in your website’s database, like product details, event registrations or other information, and you want to show it directly to your visitors. By displaying data from the database directly, you can present dynamic content in an organised manner without manually updating it.

With the Table widget from The Plus Addons for Elementor, you can easily show the database entries in a table using a SQL query.

*To check the complete feature overview documentation of The Plus Addons for Elementor Table widget, [click here](/docs/table-elementor-widget-settings-overview/).*

***Requirement  - This widget is a part of The Plus Addons for Elementor, make sure it's installed & activated to enjoy all its powers.***

[LIVE WIDGET LINK](https://theplusaddons.com/elementor-widget/elementor-data-table/?utm_source=tpae&utm_medium=docs&utm_campaign=text)

To do that, add the Table widget from The Plus Addons for Elementor to the page and follow the steps - 

1. Select **SQL Query** from the **Content Table** dropdown.

> *Note: Make sure you’ve enabled the SQL Query toggle from the Table Features popup to see the option.*

2. Then, in the **SQL Query** field, you have to add your SQL query. 

For example, if we add this query 

`SELECT ID, post_title, post_date FROM wp_posts WHERE post_status = 'publish' AND post_type = 'post' LIMIT 10;`

This will show the first 10 published blog posts from the wp_posts table, displaying each post’s ID, title, and publish date in the table.

You can use ${prefix} as a placeholder for the WordPress core tables so it matches your site’s table prefix.

For example, if you are using a different prefix like “mywp_” instead of the default “wp_”, then   “${prefix}posts” will automatically become “mywp_posts”.

> *Note: You can’t show data from the user table.*

But for custom tables, you have to use the actual table name.

From the **Refresh Time** dropdown, you can select how often new data will be pulled from that particular database table.

But if you want to pull fresh data from that particular database table before that specific time, you can click the **Delete** button in the **Delete All Transient** section. This will delete the existing data and add new data from that particular database table. 

So this is how easily you can show data from the database in a table.

## Frequently Asked Questions

**Q: What do I need before starting to show WordPress database entries in an Elementor table?**
A: You need to have The Plus Addons for Elementor installed and activated to use the Table widget for displaying database entries.

**Q: How do I add a SQL query to display data in the Elementor table?**
A: To add a SQL query, select SQL Query from the Content Table dropdown in the Table widget settings. Ensure the SQL Query toggle is enabled to see this option.

**Q: What happens if I use the placeholder ${prefix} in my SQL query?**
A: Using ${prefix} as a placeholder in your SQL query will automatically match your site's table prefix, allowing for flexibility with custom prefixes like 'mywp_' instead of 'wp_'.

**Q: Can I display data from the user table using The Plus Addons for Elementor?**
A: You cannot show data from the user table using The Plus Addons for Elementor. The widget is limited to other database tables.

**Q: Is there a way to refresh the data displayed in the Elementor table?**
A: Yes, you can set the Refresh Time from the dropdown to determine how often new data is pulled from the database table. You can also manually refresh by clicking the Delete button in the Delete All Transient section.

**Q: What SQL query example can I use to display blog posts in the Elementor table?**
A: An example SQL query to display blog posts is 'SELECT ID, post_title, post_date FROM wp_posts WHERE post_status = 'publish' AND post_type = 'post' LIMIT 10', which shows the first 10 published posts.