# Sum data in mysql query

**URL:** <https://discourse.laminas.dev/t/sum-data-in-mysql-query/2328>\
**Category:** Components & MVC\
**Tags:** laminas-db\
**Created:** [June 1, 2021, 2:38am UTC](https://discourse.laminas.dev/t/sum-data-in-mysql-query/2328 "2021-06-01T02:38:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![amy0812](https://yyz2.discourse-cdn.com/flex032/user_avatar/discourse.laminas.dev/amy0812/32/1008_2.png) [@amy0812](https://discourse.laminas.dev/u/amy0812)\
**Post date:** [June 1, 2021, 2:38am UTC](https://discourse.laminas.dev/t/sum-data-in-mysql-query/2328/1 "2021-06-01T02:38:29Z")

</div>

Hi all, i’m using laminas mvc, how to sum a column in mysql query ?

---

<div class="post-metadata">

**Author:** ![froschdesign](https://yyz2.discourse-cdn.com/flex032/user_avatar/discourse.laminas.dev/froschdesign/32/38_2.png) [@froschdesign](https://discourse.laminas.dev/u/froschdesign)\
**Post date:** [June 2, 2021, 6:47am UTC](https://discourse.laminas.dev/t/sum-data-in-mysql-query/2328/2 "2021-06-02T06:47:58Z")

</div>

> [@amy0812](#):
>
> i’m using laminas mvc

Via an `Expression` object:

```php
$select->columns(['my_name' => new Laminas\Db\Sql\Expression('SUM(something)')]);

```