# Email Field Mapping - JDBC River

**URL:** <https://discuss.elastic.co/t/email-field-mapping-jdbc-river/26017>\
**Category:** Elasticsearch\
**Created:** [July 21, 2015, 7:18pm UTC](https://discuss.elastic.co/t/email-field-mapping-jdbc-river/26017 "2015-07-21T19:18:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Garrett\_Johnson](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@Garrett\_Johnson](https://discuss.elastic.co/u/Garrett_Johnson)\
**Post date:** [July 21, 2015, 7:18pm UTC](https://discuss.elastic.co/t/email-field-mapping-jdbc-river/26017/1 "2015-07-21T19:18:17Z")

</div>

I'm using the JDBC river (sad it is deprecated but understand why).

I created all my items in all indexes with the river using a column strategy etc.

So I've never really indexed anything. I see the Get Mapping and Put Mapping API's. And I was able to get my mapping.

"Email":{"type":"string"} (that's it for the email address)....

How do I make it so that the following works:

search for [garrett@abc123.com](mailto:garrett@abc123.com) searches for exactly that.  
search for anyone @abc123.com before garrett.

i'm reading about custom analyzers but i'm not sure how to implement them.

Anyone have a good guide. Our documents can have 100's of fields (bad data design). so they are very unwieldy.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 12:00am UTC](https://discuss.elastic.co/t/email-field-mapping-jdbc-river/26017/2 "2017-07-06T00:00:05Z")

</div>


