Re: equal to 0 if negative

[laptop alias]

How about...?

CREATE TABLE test (score INT UNSIGNED);

INSERT INTO test VALUES (1);
INSERT INTO test VALUES (0);
INSERT INTO test VALUES (-4);

SELECT * FROM test;
+-------+
| score |
+-------+
|     1 |
|     0 |
|     0 |
+-------+