sort mysql table

[eleanor]

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]

I solved it like this:

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

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

To copy to clipboard, switch view to plain text mode 

works like a charm...for now

[maverick_pol]

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!