# \#text-index

**URL:** https://community.neo4j.com/tag/text-index/623.md

[Latest](https://community.neo4j.com/latest.md) · [Categories](https://community.neo4j.com/categories.md) · [Tags](https://community.neo4j.com/tags.md)

---

## [How does text index(not Full-text index) work?](https://community.neo4j.com/t/how-does-text-index-not-full-text-index-work/71807)

<div class="topic-metadata">

**Author:** [@abccbaandy](https://community.neo4j.com/u/abccbaandy)\
**Replies:** 6\
**Last updated:** [January 25, 2025, 7:04am UTC](https://community.neo4j.com/t/how-does-text-index-not-full-text-index-work/71807 "2025-01-25T07:04:46Z")

</div>

In mysql there is no such index, and WHERE n.name like '%William%' is bad practice. In neo4j, with text index, it's seems normal to run WHERE n.name CONTAINS 'William' But I can't find any detail about how it work. …

---

## [About cypher text index only supporting optimization using operators of "contains" and "ends with"](https://community.neo4j.com/t/about-cypher-text-index-only-supporting-optimization-using-operators-of-contains-and-ends-with/71122)

<div class="topic-metadata">

**Author:** [@h.wei](https://community.neo4j.com/u/h.wei)\
**Replies:** 2\
**Last updated:** [October 23, 2024, 3:17pm UTC](https://community.neo4j.com/t/about-cypher-text-index-only-supporting-optimization-using-operators-of-contains-and-ends-with/71122 "2024-10-23T15:17:11Z")

</div>

I don't know if someone can kindly elaborate the reason beneath it. For example, why operator "starts with" is not optimized. Thank you so much.