Reverse string function to reverse and update table field

SELECT REVERSE('abcdef gh i')

The output

i hg fedcba

We can reverse a string by using reverse command in mysql. This function takes one input string and reverses it.

Now let us apply this reverse command to our student table like this.

select reverse(name) from student

It will display all the names by reversing the names. We can update the names like this

update student set name = reverse(name)

It will update all the records of student table by reversing it. If you want to get back all your names then run the command once again.

PHP Script

MySQLi database connection string

require "config.php";// Database connection

$query="SELECT REVERSE(name) FROM `student` ";
if ($result_set = $connection->query($query)) {
while($row = $result_set->fetch_array(MYSQLI_ASSOC)){
echo $row['REVERSE(name)']."<br>";
}
 $result_set->close();
}

Output ( 5 records shown only )

niuR xaM
dlonrA
boR nhoJ yM
diursA
yrQ seT

SQL String References Number of bytes present in a string

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

Reversing string function of MySQL

PHP Script

Subhendu Mohapatra