I have a table named `articles` with a column named `price`. 

When a user on my web app selects both `Price Min` and `Price Max`, I need to perform a query like this: 

```
$priceMin = 100000;
$priceMax = 10000000;

$query = 'SELECT * FROM articles WHERE price BETWEEN $priceMin AND $priceMax';

```

However, when the selected `Price Min is <= 100000` and `Price Max is >= 10000000` (10 Million), I don't have any output with a `Price` greater than `900000` even though rows with values above `900000` do exist. 

The table is defined like this:

```
CREATE TABLE articles ( 
 id int(11) NOT NULL AUTO_INCREMENT, 
 name varchar(100) NOT NULL, 
 price varchar(100) NOT NULL, 
 source varchar(255) NOT NULL, PRIMARY KEY (id) 
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 

```