# Change field from text to lookup

**URL:** <https://forum.mautic.org/t/change-field-from-text-to-lookup/3354>\
**Category:** Product Support\
**Created:** [January 30, 2016, 7:10pm UTC](https://forum.mautic.org/t/change-field-from-text-to-lookup/3354 "2016-01-30T19:10:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ramez\_rafla](https://avatars.discourse-cdn.com/v4/letter/r/8c91f0/32.png) [@ramez\_rafla](https://forum.mautic.org/u/ramez_rafla)\
**Post date:** [January 30, 2016, 7:10pm UTC](https://forum.mautic.org/t/change-field-from-text-to-lookup/3354/1 "2016-01-30T19:10:12Z")

</div>

Is there an easy way to change a field from text to lookup? Right now field types get frozen once created. Even an SQL query (or its foundation) would suffice. Thanks!

---

<div class="post-metadata">

**Author:** ![ramez\_rafla](https://avatars.discourse-cdn.com/v4/letter/r/8c91f0/32.png) [@ramez\_rafla](https://forum.mautic.org/u/ramez_rafla)\
**Post date:** [January 30, 2016, 7:10pm UTC](https://forum.mautic.org/t/change-field-from-text-to-lookup/3354/2 "2016-01-30T19:10:12Z")

</div>

Is there an easy way to change a field from text to lookup? Right now field types get frozen once created. Even an SQL query (or its foundation) would suffice. Thanks!