24

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!

pmerino
  • 5,900
  • 11
  • 57
  • 76

1 Answers1

68
UPDATE users SET role=99 WHERE name='Fred'
Graham Borland
  • 60,055
  • 21
  • 138
  • 179