|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
05-31-2007, 8:39 PM
| #1 | ||
 |
"MOOXE" <mooxe@hotmail.com> wrote in message news  o2dnaqky41IMxPfRVn-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 <> '' | ||
     |
| Advertisements |
|
05-31-2007, 8:39 PM
| #2 | ||
| |
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 o2dnaqky41IMxPfRVn-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 <> '' > > > | ||
| |
|
05-31-2007, 8:39 PM
| #3 | ||
| |
"MOOXE" <mooxe@hotmail.com> wrote in message news:Q7OdnVQfU4UFphLfRVn-jQ@rogers.com... > That worked perfectly, thank you. I have a lot to learn it seems.... > > Andrew > Well everyone has to start somewhere ;-) Good luck ! | ||
| |
| Featured Websites | ||||
|
|
| Tags: lost, newbie, question, sql |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Newbie Mod Chip Question | Mother Focus | Computer Consoles | 14 | 06-10-2007 9:05 PM |
| Newbie Mod Chip Question | alia | Computer Consoles | 0 | 05-29-2007 10:17 AM |
| Total newbie: an erasing question | Matt Shepherd | Graphics in general | 3 | 05-28-2007 7:58 PM |
| A newbie question about NVU (templates) | grubas8@gazeta.pl | Website Reviews And Website Questions | 1 | 05-28-2007 12:42 AM |
| PR lost its way? | FURiON | Search Engine Optimization | 2 | 08-29-2006 1:32 AM |
| Featured Websites | ||||
|
Newbie SQL question... (I am lost!) 
PacMan
Linear Mode
