MySql auto_increment plus a certain number

Question

I want my the id field in my table to be a bit more " random" then consecutive numbers.

Is there a way to insert something into the id field, like a +9, which will tell the db to take the current auto_increment value and add 9 to it?

Answer 1

You have a design flaw. Leave the auto increment alone and shuffle your query result (when you fetch your data)