|
Posted by Matthias Hoys on 05/21/05 13:52
"MOOXE" <mooxe@hotmail.com> wrote in message
news:So2dnaqky41IMxPfRVn-sQ@rogers.com...
Howdy All...
I am very new and am bashing through this SQL quite slowly on my own....
Recently I needed to run a query, one which I could not figure out how to
contruct....
Heres what I need to do...
SELECT * FROM `test` WHERE `user_actkey` = (anything but a blank entry, I
dont know what the syntax would be)
After the query finds all entries that have anything but a blank entry I
want to change the `user_active` field value entry to 1 for each one.
This is really as far as I know what do which is barely a start... Hopefully
theres some help out there! Thanks to all...
Andrew
Try this :
UPDATE test SET user_actkey = 1 WHERE user_actkey <> ''
Navigation:
[Reply to this message]
|