How to use the SPACE() function with the MySQL WHERE clause?

In this case, the SPACE() function will add spaces based on the conditions given in the WHERE clause. The following example from the Students table demonstrates this.

Example

mysql> Select Id,Name,Space(5) from student WHERE Name='Harshit';
+------+---------+----------+
| Id   | Name    | Space(5) |
+------+---------+----------+
| 15   | Harshit |          |
+------+---------+----------+
1 row in set (0.00 sec)

The above is the detailed content of How to use the SPACE() function with the MySQL WHERE clause?. For more information, please follow other related articles on the PHP Chinese website!