Hello and thanks for checking this out… My aider!

I’m trying to get some values from

a selected row in MySQL table

The table looks like this;

```
class. subject. score.
----------------------------
A. maths. 45
----------------------------
B. phys. 50
----------------------------
B. phys. 70
----------------------------
A. maths. 65
----------------------------
B. phys. 50
----------------------------
A. maths. 55
----------------------------
B. phys. 50
----------------------------
A. maths. 65
----------------------------
B. phys. 55
----------------------------
A. maths. 95
----------------------------
B. phys. 40
```

Now I want to fetch 3 random score from Maths as subject

Also fetch 3 random score from Phys as subject

How do I fetch these values using PHP and MySQL ?

Thanks