Displays one record when querying the database?

Question

PHP

Essence:
Query to the database via SQL query to display data of all columns using PhpMyAdmin. Filtering when querying as `NameColumn` LIKE '%123%'. There are 5/6 records in the database, but only the first record is displayed.
The request itself:

SELECT * FROM `NameTable` WHERE `NAMECOLUMN` LIKE '%123%'

Causes and solutions to the problem, thanks in advance!

Answer 1

Judging by the text of the question, the answer to the question in the title will be: "Yes, displays one."