SPACE to add or update string with space in a query

SPACE(): to add space in Query

SPACE Query takes integer N as argument.

SELECT SPACE (15)

We can add one start and end string to display the space between them

SELECT  '#', SPACE( 15 ) ,  '#'

Output is here

#	             	#

We can use SPACE with our student table

SELECT  name , SPACE(10), class , mark, sex  FROM `student`

name	class	mark	sex
John Deo	Four	75	female
Max Ruin	Three	85	male
Arnold	Three	100	male
Krish Star	Four	60	female
John Mike	Four	60	female
Alex John	Four	55	male

SPACE with UPDATE Query

We can add blank space to data in a Column by using update query

UPDATE student set name=CONCAT(space(5),name)

We added space before all names in our student table.

CONCAT to add string

Removing Space

To remove space from Left we can use LTRIM, to remove space from Right we can use RTRIM and to remove from both sides we can use TRIM

PHP Script

MySQLi database connection string

require "config.php";// Database connection
$query="SELECT  name , SPACE(10), class FROM `student`";
if ($result_set = $connection->query($query)) {
while($row = $result_set->fetch_array(MYSQLI_ASSOC)){
echo $row['name'],$row['SPACE(10)'],$row['class']."<br>";
}
 $result_set->close();
}

SQL String References elt(): String from the postion

Subscribe to our YouTube Channel here

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com