|
Posted by MOOXE on 05/21/05 16:50
That worked perfectly, thank you. I have a lot to learn it seems....
Andrew
"Matthias Hoys" <idmwarpzone_NOSPAM_@yahoo.com> wrote in message
news:428f130b$0$26071$ba620e4c@news.skynet.be...
>
> "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]
|