PDA

View Full Version : sort mysql table



eleanor
10th October 2007, 16:43
Hi, I want to sort mysql table alphabetically (without case sensitivity).

I have a bunch of names in it and I want to have a method in QT program, that would change mysql table (names woule be sorted alphabetically)

So any idea how to do that?

eleanor
10th October 2007, 17:40
I solved it like this:



QSqlQuery query("SELECT ime,postna_st FROM kraj ORDER BY ime");


works like a charm...for now:)

maverick_pol
10th October 2007, 17:42
Hi,

You have selected data in a sorted manner, but the table will not change.


I want to have a method in QT program, that would change mysql table


But if this works fine, better for you. : )

Good luck!