Add column to user table?

[high6]

How would you add an md5 of the username as a column to the user table? And how would you keep them synced?

[Andrew Green]

ALTER TABLE user ADD COLUMN usernamehash CHAR(32);
UPDATE TABLE user SET usernamehash = MD5(username);

Although I'm not sure what purpose that could serve...

[high6]

But what about when a user registers or when a users name is changed?

[Lynne]

Originally Posted by high6

But what about when a user registers or when a users name is changed?

You would have to write a couple of plugins to write to/update the column at each of those times.

[Andrew Green]

Are you sure you need this? It seems rather unnecessary.

SELECT MD5(username) FROM user WHERE userid = ___;

you can have a MD5 whenever you want it, without adding a column or having to worry about syncing.

[high6]

Well I am provided an md5 of the username and I need to get the row in the user table with it.

Andrew would this be possible? SELECT * FROM user WHERE MD5(username)='hash'?