How to make a search on the site and output on request?

Question

CMS

The essence of the question on the TK:
1. Create a site (it is possible on a CMS, probably it is necessary and this is not a problem for me on Joomla)
2. Provide the ability to register users (in principle, the registration form is not a problem that is contained in Joomla)
3. Create a database with 4 columns where there are restrictions (in column 1 there are only numeric values ​​no more than 25 characters, in column 4 there are only 5 ready-made options)
4. Give users the right to add new rows
5. Attach a search form from the database to the main page for only 1 row
You need a database so that in the future you can easily reconfigure the site and everything works on this built experience for the implementation of the current task.
I ask for help from point number 3 - how to implement it?

Answer 1

Maybe a simple phpMyEdit will suit you, and you don't need a whole CMS?
Well, on the CMS - see the docks, how to write modules and API for working with the database.

Answer 2

I decided that it is not necessary to create a new database, just one table is needed.
I will create it through phpMyAdmin, enter the necessary lines into it, but how then to form a query on the first column to display the whole line?
those. we are looking for only the data in the first column, and output the whole line with matches