How to get text from a number in a select query : <p>there I have MYSQL DB, and it has an ID INT, however this identifier has a meaning in the system, I would like to get the meaning instead of the number for example something like this.</p>

<pre><code>select ID from payments;
if(ID==0)
returns "No payment made"
else if(ID==1)
returns "Payment made accordingly"
</code></pre>

<p>Is it possible to do that ? or should I do it programatically? in the system?,
I'm using a datagridview in C# and that is why I want to get the result as a text and not a number from the query</p>
