Table of Contents for

MySQL in a Nutshell, 2nd Edition

This function returns a string of spaces. The number of spaces returned is set by the argument. Here is an example:

SELECT CONCAT(name_first, SPACE(1), name_last)
AS Name
FROM students LIMIT 1;

+------------------+
| Name             |
+------------------+
| Richard Stringer |
+------------------+

Although this example requires a lot more typing than just placing a space within quotes, it’s more apparent when glancing at it that a space is to be inserted. For multiple or variable spaces, you could substitute the count with another function to determine the number of spaces needed based on data from a table, the length of other inputs, or some other factor.