> For the complete documentation index, see [llms.txt](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/advanced-sql/text-operations/contains.md).

# Contains

**contains** is used to check membership. It is index-based and word-oriented.

It is used for clob data type, on larger pieces of text.

It is much more powerful (also includes ranking)

It is also faster than like in many cases because it uses index

However, we must build the index first (**create index** … )

Example:

```
SELECT * FROM Table WHERE CONTAINS(name, 'Vikram', 1)>0;
```