SQL PHP HTML ASP JavaScript articles and free scripts to download
SQL String Functions

Reversing string function of MySQL

We can reverse a string by using reverse command in mysql. This function takes one input string and reverses it. Here is an simple example.

SELECT reverse('abcdef gh i')

The output of this is i hg fedcba 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.

Be the first to post comment on this article :


Google+

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



Join Our Email List
Email:  
For Email Newsletters you can trust

HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer