Sqlite – How to change a value in a column on a SQLite database


I have a SQLite database with this format:

TABLE users
    |---------name - text
    |---------avatar - text
    |---------password - text
    |---------userdir - text
    |---------role - numeric

I want to change the number of role. How could I change it? (I mean, what query?)

I'm using PHP if anyone needs it. Thanks!

Best Solution

UPDATE users SET role=99 WHERE name='Fred'