Okay so I have a project on going and people pay for licenses and once a license is activated from the project it auto enters there hwid into the mysql DB.
So what I'm trying to do is for instance if column license key consists of license key "TEST-TEST-TEST=T" then set the hwid = "Not Set".
I've tried this sql query for instance.
UPDATE table-name-here SET hwid= 'Not Set' WHERE licensekey = 'TEST-TEST-TEST=T'
and the sql command will then return hwid value not to be set again.
Can any sql experts give me a hand on this please? Appreciated.
Ok Ive managed to do it, was a small error my end, I put a cap S for sent when it needed a small s.
So here is the fix for others who want to use this sort of query.
UPDATE yourtablename SET hwid = 'Not set' WHERE licensekey = 'TEST-TEST-TEST=T'