{"id":97666,"date":"2020-12-07T11:00:00","date_gmt":"2020-12-07T09:00:00","guid":{"rendered":"https:\/\/examples.javacodegeeks.com\/?p=97666"},"modified":"2022-02-24T12:07:31","modified_gmt":"2022-02-24T10:07:31","slug":"sql-like-sql-not-like","status":"publish","type":"post","link":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/","title":{"rendered":"SQL Like – SQL Not Like"},"content":{"rendered":"

In this article, we will be exploring the SQL Like and the SQL Not Like operators. These operators help in filtering specific patterns from the columns. <\/p>\n

1. About SQL Like & SQL Not Like<\/h2>\n

Let us start with understanding what both these operators are. <\/p>\n

1.1 What is SQL Like operator?<\/h3>\n

The SQL Like<\/code> operator is used to filtering the data according to a specific pattern in a particular column. This operator comes in the WHERE clause of the query. <\/p>\n

There are wildcard symbols, which represent the pattern we want to retrieve from the table. Some of the most frequently used wildcard symbols are:<\/p>\n

    \n
  1. % – This percentage wildcard symbol represents zero, one or more characters. <\/li>\n
  2. _ – This underscore wildcard symbol represents exactly 1 character. <\/li>\n<\/ol>\n

    1.2 What is SQL Not Like operator?<\/h3>\n

    The SQL Not Like<\/code> the operator works in a way opposite to that of the operator. The SQL Not Like<\/code> operator excludes the matching pattern from the specific column. <\/p>\n

    Similarly, the SQL Not Like<\/code> operator uses the wildcard symbols as well. <\/p>\n

    2. Syntax <\/h2>\n

    Now that we know what each of the operators does, we are going to look at the syntax for both of the operators.

    <\/div> <\/div><\/p>\n

    2.1 SQL Like operator syntax<\/h3>\n
    SELECT column1, column2 FROM tableName WHERE columnName LIKE patern<\/pre>\n
    2.2 SQL Not Like operator syntax<\/h3>\n
    SELECT column1, column2 FROM tableName WHERE columnName NOT LIKE patern<\/pre>\n
    3. Example<\/h2>\n
    Finally, we will see the usage of SQL like<\/code> and SQL Not Like<\/code> operators with an example. <\/p>\n
      \n
    1. Let us start with creating a database named data and subsequently a table named student. <\/li>\n<\/ol>\n
      \n
      \"SQL
      Creating database – data and table – student<\/figcaption><\/figure>\n<\/div>\n
      2. Now, let us insert some rows of data using the SQL Insert Into statement. <\/p>\n
      \"SQL
      Inserting data into table <\/figcaption><\/figure>\n
      3. Let us now use the SQL Like<\/code> operator. We have used the SQL Like<\/code> operator to filter on the basis of – all names starting with A, all names starting with A, and third letter as all names with A as the second letter. <\/p>\n
      \"SQL
      Examples using Like operator<\/figcaption><\/figure>\n
      4. Now, let us now use the SQL Not Like<\/code> operator. We have used the SQL Not Like operator to filter on the basis of – all country names which don’t start with ‘I’, all country names with don’t end with ‘a’, and country names which neither start with ‘A’ nor end with ‘a’.<\/p>\n
      \"SQL
      Examples using Not Like operator<\/figcaption><\/figure>\n
      4. Summary<\/h2>\n
      In this article, we discuss the two operators SQL Like<\/code> and SQL Not Like<\/code>. We also discussed the wildcard symbols like the percent (%) symbol, and underscore ( _ ) symbol. <\/p>\n
      5. Download the source code<\/h2>\n
      To implement the examples implemented above, download the source code.<\/p>\n
      Download<\/strong>
      \nYou can download the full source code of this example here: SQL Like – SQL Not Like<\/strong><\/a><\/div>\n
      Last updated on Feb. 24th, 2022<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"
      In this article, we will be exploring the SQL Like and the SQL Not Like operators. These operators help in filtering specific patterns from the columns. 1. About SQL Like & SQL Not Like Let us start with understanding what both these operators are. 1.1 What is SQL Like operator? The SQL Like operator is …<\/p>\n","protected":false},"author":234,"featured_media":1204,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[1055],"class_list":["post-97666","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-sql"],"yoast_head":"\nSQL Like - SQL Not Like - Java Code Geeks<\/title>\n<meta name=\"description\" content=\"The SQL Like operator is used to filtering the data according to a specific pattern in a particular column.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Like - SQL Not Like - Java Code Geeks\" \/>\n<meta property=\"og:description\" content=\"The SQL Like operator is used to filtering the data according to a specific pattern in a particular column.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/\" \/>\n<meta property=\"og:site_name\" content=\"Examples Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-07T09:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-24T10:07:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Simran Koul\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simran Koul\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/\"},\"author\":{\"name\":\"Simran Koul\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c\"},\"headline\":\"SQL Like – SQL Not Like\",\"datePublished\":\"2020-12-07T09:00:00+00:00\",\"dateModified\":\"2022-02-24T10:07:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/\"},\"wordCount\":410,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"keywords\":[\"sql\"],\"articleSection\":[\"sql\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/\",\"name\":\"SQL Like - SQL Not Like - Java Code Geeks\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"datePublished\":\"2020-12-07T09:00:00+00:00\",\"dateModified\":\"2022-02-24T10:07:31+00:00\",\"description\":\"The SQL Like operator is used to filtering the data according to a specific pattern in a particular column.\",\"breadcrumb\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#primaryimage\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"width\":150,\"height\":150,\"caption\":\"Bipartite Graph\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/examples.javacodegeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java Development\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Core Java\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"sql\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"SQL Like – SQL Not Like\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Examples and Code Snippets\",\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/javacodegeeks\",\"https:\/\/x.com\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c\",\"name\":\"Simran Koul\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png\",\"caption\":\"Simran Koul\"},\"description\":\"Simran has graduated as a Bachelor of Engineering in Computer Science from Chitkara University. She has undergone a 6-months long comprehensive industrial training at the reputed Centre for Development of Advanced Computing (C-DAC), where she worked on a project including the likes of Java, JSP, Servlets while the UI-UX through the pioneering HTML, CSS and JS. Her inquisitive nature and the seed of curiosity keeps her on the toes to find material to write about. Along with her interests in Software Development, she is an ardent reader and always ready-to-write writer.\",\"url\":\"https:\/\/examples.javacodegeeks.com\/author\/simran-koul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Like - SQL Not Like - Java Code Geeks","description":"The SQL Like operator is used to filtering the data according to a specific pattern in a particular column.","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:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/","og_locale":"en_US","og_type":"article","og_title":"SQL Like - SQL Not Like - Java Code Geeks","og_description":"The SQL Like operator is used to filtering the data according to a specific pattern in a particular column.","og_url":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/","og_site_name":"Examples Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_published_time":"2020-12-07T09:00:00+00:00","article_modified_time":"2022-02-24T10:07:31+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","type":"image\/jpeg"}],"author":"Simran Koul","twitter_card":"summary_large_image","twitter_creator":"@javacodegeeks","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"Simran Koul","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#article","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/"},"author":{"name":"Simran Koul","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c"},"headline":"SQL Like – SQL Not Like","datePublished":"2020-12-07T09:00:00+00:00","dateModified":"2022-02-24T10:07:31+00:00","mainEntityOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/"},"wordCount":410,"commentCount":0,"publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","keywords":["sql"],"articleSection":["sql"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/","url":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/","name":"SQL Like - SQL Not Like - Java Code Geeks","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#primaryimage"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","datePublished":"2020-12-07T09:00:00+00:00","dateModified":"2022-02-24T10:07:31+00:00","description":"The SQL Like operator is used to filtering the data according to a specific pattern in a particular column.","breadcrumb":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#primaryimage","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","width":150,"height":150,"caption":"Bipartite Graph"},{"@type":"BreadcrumbList","@id":"https:\/\/examples.javacodegeeks.com\/sql-like-sql-not-like\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/examples.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java Development","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/"},{"@type":"ListItem","position":3,"name":"Core Java","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/"},{"@type":"ListItem","position":4,"name":"sql","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/"},{"@type":"ListItem","position":5,"name":"SQL Like – SQL Not Like"}]},{"@type":"WebSite","@id":"https:\/\/examples.javacodegeeks.com\/#website","url":"https:\/\/examples.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Examples and Code Snippets","publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/examples.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/examples.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c","name":"Simran Koul","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png","caption":"Simran Koul"},"description":"Simran has graduated as a Bachelor of Engineering in Computer Science from Chitkara University. She has undergone a 6-months long comprehensive industrial training at the reputed Centre for Development of Advanced Computing (C-DAC), where she worked on a project including the likes of Java, JSP, Servlets while the UI-UX through the pioneering HTML, CSS and JS. Her inquisitive nature and the seed of curiosity keeps her on the toes to find material to write about. Along with her interests in Software Development, she is an ardent reader and always ready-to-write writer.","url":"https:\/\/examples.javacodegeeks.com\/author\/simran-koul\/"}]}},"_links":{"self":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/97666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/users\/234"}],"replies":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=97666"}],"version-history":[{"count":0,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/97666\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media\/1204"}],"wp:attachment":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=97666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=97666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=97666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}