I want to run a MySQL query like this-

```
 SELECT country_ID*2/id*3.159 as my_id
 FROM `state`
 WHERE my_id>2;

```

When I run it, I am getting an error like this-

> 
> 1054 - Unknown column 'my\_id' in 'where clause' 
> 
> 
> 

Is there any alternative solution to search in my new created virtual column **my\_id** ?

---

Actually I am trying to make a search in **[Laravel Query Builder](http://laravel.com/docs/4.2/queries)** like this-

```
  DB::table(    'project')->select( 'project.id as id',
                                    'project.completion_date as completion_date',
                                     DB::raw('FORMAT(project.total_cost_to_dispose - project.actual_cost_dispose, 2) as disposal_savings')
                                   )
                            ->where(disposal_savings>100);

```

Can I do it?

If not, then what is the solution in Laravel or MySQL?