{"id":11837,"date":"2019-05-29T13:08:50","date_gmt":"2019-05-29T13:08:50","guid":{"rendered":"https:\/\/dbtut.com\/?p=11837"},"modified":"2019-07-23T13:40:08","modified_gmt":"2019-07-23T13:40:08","slug":"search-a-keyword-in-elasticsearch-using-kibana","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/","title":{"rendered":"Search a Keyword in Elasticsearch using Kibana"},"content":{"rendered":"

We mentioned that Elasticsearch is a search engine in the article “What is Elasticsearch<\/a>“. Searching for a keyword in Elasticsearch is very fast. In this article we will talk about the search types in elasticsearch. You may want to read the following articles before reading this article.<\/p>\n

“What is Kibana<\/a>“,<\/p>\n

“How To Install Elasticsearch On Centos<\/a>“,<\/p>\n

“How To Install Kibana On Centos<\/a>”<\/p>\n

We’re connecting to Kibana for keyword search and we click on Discover and Relative from Time Range as you see in the screenshot below. If the data you export to elasticsearch has a date column, you will see a screen as follows.<\/p>\n

In the following screenshot, we indicate that we will search within the last 15 minutes.<\/p>\n

\"\"<\/p>\n

If you click Quick from Time Range, the following options are available.<\/p>\n

\"\"<\/p>\n

If you click Absolute from Time Range, you can select the time interval you want to search for from a calendar.<\/p>\n

\"\"<\/p>\n

Then, type the keyword you want to search in the marked field in the following screenshot, and press enter. The found keywords will be listed in yellow as below.<\/p>\n

\"\"<\/p>\n

Search Types<\/h2>\n

Search for a keyword in all data<\/h3>\n

If you type the keyword you’re looking for in the search section, it searches for the relevant keyword in all data.<\/p>\n

Search for a keyword in a specific column<\/h3>\n

If you type column_name: keyword<\/code> in the search section, it will search only the related keyword in the corresponding column.<\/p>\n

Example:<\/strong><\/p>\n

fileset.name:syslog<\/pre>\n
Search With AND && OR Operators<\/h3>\n
You can use AND and OR operators as follows.<\/p>\n
fileset.name:syslog AND fileset.module=system<\/pre>\n
fileset.name:syslog OR fileset.module=system<\/pre>\n
\"\"<\/p>\n
LIKE Usage<\/h3>\n
You must type the keyword you want to search between two asterisks.<\/p>\n
*sys*<\/pre>\n
You can also search in a specific column in the following way.<\/p>\n
fileset.name:*sys*<\/pre>\n
\"\"<\/p>\n\n
\n
\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
We mentioned that Elasticsearch is a search engine in the article “What is Elasticsearch“. Searching for a keyword in Elasticsearch is very fast. In this article we will talk about the search types in elasticsearch. You may want to read the following articles before reading this article. “What is Kibana“, “How To Install Elasticsearch On …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":11850,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3654,3652],"tags":[3639,3638,3641,3631,3630,3634,3635,3633,3640,3637,3632,3636,3629,3627,3628],"class_list":["post-11837","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-analyticdashboard","category-elk","tag-elasticsearch-and-operator","tag-elasticsearch-bool-query","tag-elasticsearch-contains-string","tag-elasticsearch-full-text-search","tag-elasticsearch-keyword-search","tag-elasticsearch-like-query","tag-elasticsearch-like-usage","tag-elasticsearch-match-multiple-fields","tag-elasticsearch-or-operator","tag-elasticsearch-query_string-filter","tag-elasticsearch-search-by-field-value","tag-elasticsearch-wildcard-query-example","tag-how-do-i-get-elasticsearch-data-in-kibana","tag-how-do-i-write-a-search-query-in-kibana","tag-what-is-elasticsearch-full-text-search"],"aioseo_notices":[],"yoast_head":"\nSearch a Keyword in Elasticsearch using Kibana - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Search a Keyword in Elasticsearch using Kibana\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Search a Keyword in Elasticsearch using Kibana - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Search a Keyword in Elasticsearch using Kibana\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-29T13:08:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-23T13:40:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-54.png\" \/>\n\t<meta property=\"og:image:width\" content=\"603\" \/>\n\t<meta property=\"og:image:height\" content=\"369\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Search a Keyword in Elasticsearch using Kibana\",\"datePublished\":\"2019-05-29T13:08:50+00:00\",\"dateModified\":\"2019-07-23T13:40:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/\"},\"wordCount\":289,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-54.png\",\"keywords\":[\"elasticsearch and operator\",\"elasticsearch bool query\",\"elasticsearch contains string\",\"elasticsearch full text search\",\"elasticsearch keyword search\",\"elasticsearch like query\",\"elasticsearch like usage\",\"elasticsearch match multiple fields\",\"elasticsearch OR operator\",\"elasticsearch query_string filter\",\"elasticsearch search by field value\",\"elasticsearch wildcard query example\",\"How do I get Elasticsearch data in Kibana?\",\"How do I write a search query in Kibana?\",\"What is Elasticsearch full text search?\"],\"articleSection\":[\"Analytic&&Dashboard\",\"ELK\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/\",\"name\":\"Search a Keyword in Elasticsearch using Kibana - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-54.png\",\"datePublished\":\"2019-05-29T13:08:50+00:00\",\"dateModified\":\"2019-07-23T13:40:08+00:00\",\"description\":\"Search a Keyword in Elasticsearch using Kibana\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-54.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-54.png\",\"width\":603,\"height\":369},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Search a Keyword in Elasticsearch using Kibana\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Search a Keyword in Elasticsearch using Kibana - Database Tutorials","description":"Search a Keyword in Elasticsearch using Kibana","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/","og_locale":"en_US","og_type":"article","og_title":"Search a Keyword in Elasticsearch using Kibana - Database Tutorials","og_description":"Search a Keyword in Elasticsearch using Kibana","og_url":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/","og_site_name":"Database Tutorials","article_published_time":"2019-05-29T13:08:50+00:00","article_modified_time":"2019-07-23T13:40:08+00:00","og_image":[{"width":603,"height":369,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-54.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Search a Keyword in Elasticsearch using Kibana","datePublished":"2019-05-29T13:08:50+00:00","dateModified":"2019-07-23T13:40:08+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/"},"wordCount":289,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-54.png","keywords":["elasticsearch and operator","elasticsearch bool query","elasticsearch contains string","elasticsearch full text search","elasticsearch keyword search","elasticsearch like query","elasticsearch like usage","elasticsearch match multiple fields","elasticsearch OR operator","elasticsearch query_string filter","elasticsearch search by field value","elasticsearch wildcard query example","How do I get Elasticsearch data in Kibana?","How do I write a search query in Kibana?","What is Elasticsearch full text search?"],"articleSection":["Analytic&&Dashboard","ELK"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/","url":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/","name":"Search a Keyword in Elasticsearch using Kibana - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-54.png","datePublished":"2019-05-29T13:08:50+00:00","dateModified":"2019-07-23T13:40:08+00:00","description":"Search a Keyword in Elasticsearch using Kibana","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-54.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-54.png","width":603,"height":369},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/29\/search-a-keyword-in-elasticsearch-using-kibana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Search a Keyword in Elasticsearch using Kibana"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11837","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=11837"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11837\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11850"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}