Jump to content

help with sql query


simun

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/166209-help-with-sql-query/#findComment-876461
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.