[Konstantinos]

Quote:

Originally Posted by GoldenLion Oh, thank you. I will divide them. But let's say a faction has 15 ranks and I want to set them to 10, this means I need to delete 5 rows. What would be the best way to do it? Doing Код: DELETE FROM factionranks WHERE ID = 0 AND Rank = 11; DELETE FROM factionranks WHERE ID = 0 AND Rank = 12; DELETE FROM factionranks WHERE ID = 0 AND Rank = 13; DELETE FROM factionranks WHERE ID = 0 AND Rank = 14; DELETE FROM factionranks WHERE ID = 0 AND Rank = 15; is not the best option I assume?

Operators work in SQL as well.

pawn Код:

DELETE FROM factionranks WHERE ID = 0 AND Rank >= 11;

or

pawn Код:

DELETE FROM factionranks WHERE ID = 0 AND (Rank >= 11 AND Rank <= 15);

Quote:

Originally Posted by GoldenLion Because that's not possible.

I was about to edit my post if you hadn't reply and say about this. It is simple - don't use an enumerator for the ranks and avoid all the complicated stuff about finding each index.