Strange mysql syntax

[JongMin]

Hi, there

 

Please see the followng query:

 

SELECT * FROM table AS t WHERE id='%1\$s' ORDER BY -t.time';

 

Could you explain what is %1\$s thing and minus sign in the ORDER BY clause?

 

Is there a website or some kind of link that I can refer to?

 

Thanks

[Jacques1]

This is hardly MySQL syntax. When you look at the context of the query, I'm sure you'll find that it's actually a sprintf() expression with “%1$s” referring to the first argument.

 

The negative sign in the ORDER BY clause might be a very odd way of getting a descending order (there's a DESC keyword for that). But then again, context is everything.