I need to change a set of identical values (CHAR type) to a new value, hopefully all in one string/command. I tried doing this:
update table
set column1 = newvalue where column1 = oldvalue
but it didn't work. ideas?
Stay away from hostway, they are good but costly, I use topclasshost.com and they are cheap, and you get your own database on their mySQL server, which is all you need. PHP too, of course.
Not sure if this is really a "function," but, here goes.
I need to perform this mathematical function on some columns in my table:
[ (a1) + (a2) + (a3) + (a4) ] / 6
Where a1, a2, a3, a4 cannot be less than zero, or greater than 2.375. How can I perform this using the SET...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.