A table called test has columns :

person\_id (Unique) & special\_num

Table:

[![Table view](https://i.stack.imgur.com/eDIZS.png)](https://i.stack.imgur.com/eDIZS.png)

Outcome :

[![outcome](https://i.stack.imgur.com/eDIZS.png)](https://i.stack.imgur.com/eDIZS.png)

Would like to create a new column called div to determine which person got the special\_num that is divisible by 10 and which person did not instead of true or false would like to have a yes or no.

I am new to MySQL and have never tried it but gave it a shot please tell me how to get this:

```
SELECT * FROM test WHERE special_num % 10 = 0 AS div from test;

```

I am unable to figure out how to input values and if it is the right way of doing it