How to Reverse the Index Direction in MySQL

Use the REVERSE function to search your tables.

When you build a database in MySQL, you can use adhoc queries to find just the information you want from your tables. At times it is helpful to reverse the order of the data stored in a particular field, and the REVERSE function lets you do just that. For instance, you might want to search through a list of email addresses by domain name instead of address. The REVERSE function makes that possible.

Difficulty:

Moderately Easy

Instructions

1. Log on to your computer and click "Start." Choose "All Programs" and then "MySQL."

2. Open the MySQL table you want to work with. Note the name of the field whose index you want to reverse.

3. Type "REVERSE('FieldName')" where 'FieldName' is the name of the field you identified in the above step. For instance, if you want to reverse the index on a field named 'email' you would type "REVERSE('email').

References

• Bit by Bit: MySQL Function of the Day