# Use full-text search for segment filters

**URL:** <https://forum.mautic.org/t/use-full-text-search-for-segment-filters/10792>\
**Category:** Ideas and Feature Requests\
**Created:** [January 30, 2019, 9:57am UTC](https://forum.mautic.org/t/use-full-text-search-for-segment-filters/10792 "2019-01-30T09:57:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Petykemano](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/petykemano/32/161_2.png) [@Petykemano](https://forum.mautic.org/u/Petykemano)\
**Post date:** [January 30, 2019, 9:57am UTC](https://forum.mautic.org/t/use-full-text-search-for-segment-filters/10792/1 "2019-01-30T09:57:37Z")

</div>

When a segment filter is performed, mautic run a query like this:

XXX

the field depends on what you search in  
and the % depends on whether you chosed contain, begin or end with filter.

Still LIKE is very slow.  
INNODB tables support Full text search from mysql 5.6. So it should be very much possible to perform these lookups with full text search instead of a full table search

---

<div class="post-metadata">

**Author:** ![Petykemano](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/petykemano/32/161_2.png) [@Petykemano](https://forum.mautic.org/u/Petykemano)\
**Post date:** [January 30, 2019, 9:59am UTC](https://forum.mautic.org/t/use-full-text-search-for-segment-filters/10792/2 "2019-01-30T09:59:16Z")

</div>

SEL ECT count(leadIdPrimary) count, max(leadIdPrimary)  
maxId, min(leadIdPrimary) minId FROM (SEL ECT DIS TINCT l.id as leadIdPrimary, OAeZCtpV.lead\_id AS OAeZCtpV\_lead\_id F  
ROM leads l LEFT JOIN lead\_lists\_leads OAeZCtpV ON OAeZCtpV.lead\_id = l.id and (OAeZCtpV.leadlist\_id = 5) WHERE (EXIS  
TS(SEL ECT NULL FROM page\_hits dEPB  
sfGI WHERE (dEPBsfGI.lead\_id = l.id) AND (dEP  
BsfGI.url LIKE ‘%SEARC HWORD%’))) AND (OAeZCtpV.lead\_id IS NULL)) sss