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.

Your Rating

String Functions
substring_index to get part of a string from a delimiter
substring Part of string from a position
concat: adding a substring to all data present in a field
character_length: Number of chars in a string
locate: searching for a matching string inside field data
character_length: length of string present in a field for each record
ucase:lower to upper and upper to lower case conversion functions
left: left part of the string data in a field
replace: replace part of a sting with sub string in a field
length: string length function
reverse: string reverse function
repeat: string repeat number of times
RIGHT: Right part of the string
lpad: string padding from left
like: String pattern matching against record

SQL Popular Tutorials

Order by displaying records Records Between two date ranges Some of the records by LIMIT query SQL SUM of data in columns

FORUM . Contact us

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