help with sql query

[simun]

i have in my query ORDER BY number DESC, and my number is 12/2212/0098 and it work fine, but i need to read that nuber reverse.

not 12/2212/0098 but 89000/2122/21, it is posible to do that?

[trq]

Numbers don't have / in them. What field type are you using?

[simun]

im using varchar

[Maq]

REVERSE().

[simun]

you mean like this

 

SELECT * FROM objects WHERE zupanija = 1  ORDER BY REVERSE (kategorizacija) DESC

 

i have try it but dont show nothing

[Maq]

First of all, do you really need every single field from that table?  You should only be selecting the fields that you are going to be using.  Second, I meant like this:

 

SELECT REVERSE(kategorizacija) FROM objects WHERE zupanija = 1 ORDER BY kategorizacija DESC

 

Did you want to order from the reversed order?  In that case, you would have to modify the query a bit and include the desired fields you're going to be using.  Since you're ordering on a VARCHAR the order will be alphabetical.  There may be a technique to order numerically, but not that I'm aware of.

[simun]

can i change varchar to something else to order it numerically

[simun]

i have a date and there for exsample, 2007-06-12, how i can dispay this in php like 12.06.2007 ???

[fenway]

i have a date and there for exsample, 2007-06-12, how i can dispay this in php like 12.06.2007 ???

With DATE_FORMAT().