How to check tinyint column value in mysql table is true or false using linux bash scripting?
<p>I have mysql database table that have the following structure</p>

<pre><code>+------+-------------+----+----+--------+----------------+
| Field| Type        |Null|Key | Default|Extra           |
+------+-------------+----+----+--------+----------------+
|id    |int(11)      |NO  |PRI | NULL   | auto_increment |
|c_date|date         |NO  |    | NULL   |                |
|c_time|time         |NO  |    | NULL   |                |
|number|varchar(11)  |NO  |    | NULL   |                |
|data  |varchar(150) |NO  |    | NULL   |                |
|isSent|tinyint(1)   |NO  |    | NULL   |                |
+------+-------------+----+----+--------+----------------+
</code></pre>

<p>What I want is to check whether isSent field's value is true or false or ,0 or 1 using a linux bash script.</p>