Need help witha couple of simple queries
 

<div>Hi,

I need to make some changes to my reputation table.

I want to do this:

For every value that is over 1 in the reputation column, change it to 1

For every value that is less than -1 (neg 1), change it to -1


Something like:

PHP Code:


or conversely

<div style="margin:20px; margin-top:5px"> PHP Code:
<div class="alt2"> <div dir="ltr" style="text-align:left;"> <span style="color: #000000"> UPDATE reputation SET reputation = -1 WHERE reputation <span style="color: #007700">