# How to use MySQL functions in DAL in shopware6?

**URL:** <https://forum.shopware.com/t/how-to-use-mysql-functions-in-dal-in-shopware6/88170>\
**Category:** Programming (EN)\
**Created:** [8. Juni 2021 um 06:58 UTC](https://forum.shopware.com/t/how-to-use-mysql-functions-in-dal-in-shopware6/88170 "2021-06-08T06:58:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![abinjohnedamana](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/abinjohnedamana/32/17378_2.png) [@abinjohnedamana](https://forum.shopware.com/u/abinjohnedamana)\
**Post date:** [8. Juni 2021 um 06:58 UTC](https://forum.shopware.com/t/how-to-use-mysql-functions-in-dal-in-shopware6/88170/1 "2021-06-08T06:58:54Z")

</div>

How to use MySQL functions in DAL?

For example how to do the following search in DAL?

`SELECT * FROM `customer\_address` WHERE LCASE(`first\_name`)='abin'`