The Select query the output of one and the same line from the same column multiple times in a row??

Example :
Is the table in the column with one value , it is necessary to take several times in a row
THAT is
| Name
| Paul
You want to bring this same line 5 times in a row due to a column using Select
| Name
| Paul
| Paul
| Paul
| Paul
| Paul

I understand it must be some sort of cycle or how should look like query
Just duplicate the line
July 9th 19 at 12:51
2 answers
July 9th 19 at 12:53
SET @i = 0;
WHILE @i < 5 
SET @i = @i + 1;
select `name` from `tablename` where `name` = "Paul" 
END
Sori I just dolbaeb, the problem recall with links and keys here infa not a complete dick pomashi that much - Anderson.Bosco30 commented on July 9th 19 at 12:56
Thank you good people - Anderson.Bosco30 commented on July 9th 19 at 12:59
that is, NP. - lily.Kozey commented on July 9th 19 at 13:02
The answer is incorrect. You will receive 5 sets of data on one line instead of one with 5 rows. - Arlo.OReill commented on July 9th 19 at 13:05
July 9th 19 at 12:55
Correct answer:
SELECT TOP (5) [table].Name
 FROM [table] a CROSS JOIN [table] AS table_5_more_rows
 WHERE ([table].Name = 'Paul')

Find more questions by tags SQLMySQL