order names from right !!!!

Hi all

I have a list of names from the world in mysql database , and i want to order it from right to left , ex :

alom
rak
gain

it's will be

1 - rak
2 - alom
3 - gain

IT'S POSSIABLE OR NOT ?

You could take the amount of characters and use a string operator to find the last letter of the word.

You could do this with PHP arrays ( www.php.net/asort, www.php.net/sort )

You could also do this by using the RIGHT function of MySQL and ordering by the result of RIGHT ( field, 1 )

thnx all

can you please give me example ?

Hi,
what about REVERSE ?

SELECT *, REVERSE(Name) AS srtfld FROM blabla ORDER BY srtfld

see you

very good 🆒

what about if i want to add some condition ex.

SELECT *, REVERSE(Name) AS srtfld FROM blabla WHERE srtfld LIKE '%$name' ORDER BY srtfld

this query return error message
Unknown column 'srtfld' in where clause

how can i use where command with that query ?

thnx alot

Try
with HAVING instead WHERE.

But remember that srtfld is reversed...

Name=bad76 => srtfld=67dab
then serach this string is
HAVING srtfld LIKE "67%" (if LIKE work with HAVING, i'm not sure...)

Else you can do this just WHERE Name LIKE "bad%"

see you

it's working 😃