Reversing string function of MySQL

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

Subscribe to our YouTube Channel here


Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com

    Post your comments , suggestion , error , requirements etc here





    SQL Video Tutorials










    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer