# I need help, search within a sql database
**URL:** https://discourse.nodered.org/t/i-need-help-search-within-a-sql-database/46977
**Category:** General
**Created:** [10 June 2021 10:43 UTC](https://discourse.nodered.org/t/i-need-help-search-within-a-sql-database/46977 "2021-06-10T10:43:50Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@ultim0](https://discourse.nodered.org/u/ultim0)
#### Post date: [10 June 2021 10:43 UTC](https://discourse.nodered.org/t/i-need-help-search-within-a-sql-database/46977/1 "2021-06-10T10:43:50Z")
I want to search for a certain table within the sql database, and view the contents of a certain period.
All via the nodered interface.
Do you have any advice ????
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [10 June 2021 11:34 UTC](https://discourse.nodered.org/t/i-need-help-search-within-a-sql-database/46977/2 "2021-06-10T11:34:42Z")
What do you mean by
> [@ultim0](#):
>
> I want to search for a certain table within the sql database
databases contain tables that have rows and columns. The first thing you need to do is learn the terms used in sql so you can pose your question properly. You can take a [tutorial at w3schools](https://www.w3schools.com/sql/default.Asp)
To get data out of the database you will need to form a sql query and use one of the sql nodes - depending of which sql you are using - and then display the results. But here again you haven explained how you want it displayed.
I recommend watching this playlist: [Node-RED Essentials](https://www.youtube.com/playlist?list=PLyNBB9VCLmo1hyO-4fIZ08gqFcXBkHy-6). The videos are done by the developers of node-red. They're nice & short and to the point. You will understand a whole lot more in about 1 hour. A small investment for a lot of gain.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [10 June 2021 14:15 UTC](https://discourse.nodered.org/t/i-need-help-search-within-a-sql-database/46977/3 "2021-06-10T14:15:52Z")
A database can contain multiple tables but it is not usual to search for a table. Do you mean that you don't know whether the database contains the expected table?
---
### Author:  [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [10 June 2021 14:40 UTC](https://discourse.nodered.org/t/i-need-help-search-within-a-sql-database/46977/4 "2021-06-10T14:40:09Z")
I guess you could try `SHOW FULL TABLES;` but must admit I've not tried it from within the node.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [9 August 2021 14:45 UTC](https://discourse.nodered.org/t/i-need-help-search-within-a-sql-database/46977/6 "2021-08-09T14:45:11Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.