{"id":24615,"date":"2018-08-15T04:00:03","date_gmt":"2018-08-15T04:00:03","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=24615"},"modified":"2021-03-11T19:02:27","modified_gmt":"2021-03-11T13:32:27","slug":"sql-like-clause","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/","title":{"rendered":"SQL Like Clause &#8211; Syntax and Example"},"content":{"rendered":"<p>In this tutorial, we will learn about the LIKE logical operator which is used for the wildcards in SQL.<\/p>\n<p>Let us now move ahead and understand the syntax and uses of the LIKE operator and then move on to the examples of the same.<\/p>\n<h3>What is LIKE Operator in SQL?<\/h3>\n<p>LIKE operator is used for operating the wildcards on our database. We use SQL wildcards when we need to search for complex data. This complex data could comprise strings or numerical with special characteristics.<\/p>\n<p>Wildcards also come in handy when we want to speed up our querying process. The results are considerably fast when wildcards are in use. We have already seen SQL Wildcards are put up with the LIKE operator.<\/p>\n<h3>Uses of LIKE Operator in SQL<\/h3>\n<p>Some of the uses of the LIKE operator are as follows:<\/p>\n<ul>\n<li>Allows us to extract data that matches the required pattern.<\/li>\n<li>Helps us to perform complex regex-based queries on our data.<\/li>\n<li>Simplifies the complex queries.<\/li>\n<\/ul>\n<h3>Rules of SQL Like Operator<\/h3>\n<p>Two main rules of Like Operator are as follows:<\/p>\n<ul>\n<li>[ % ] &#8211; Represents zero, one, or multiple characters.<\/li>\n<li>[ _ ] &#8211; Represents one single character.<\/li>\n<\/ul>\n<p>We can go through the following table to understand the Like operator in further details.<\/p>\n<table style=\"height: 406px;\" width=\"935\">\n<tbody>\n<tr>\n<td><b>Sr. No<\/b><\/td>\n<td><b>Usage with LIKE operator<\/b><\/td>\n<td><b>Description<\/b><\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td><span style=\"font-weight: 400;\">WHERE columnName LIKE \u2018a%\u2019<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns values which start with \u2018a\u2019.<\/span><\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td><span style=\"font-weight: 400;\">WHERE columnName LIKE \u2018%a\u2019<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns values which end with \u2018a\u2019.<\/span><\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td><span style=\"font-weight: 400;\">WHERE columnName LIKE \u2018%ab%\u2019<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns any value that has \u2018ab\u2019 in any position.<\/span><\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td><span style=\"font-weight: 400;\">WHERE columnName LIKE \u2018_a%\u2019<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns any value which has \u2018a\u2019 as the second character.<\/span><\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td><span style=\"font-weight: 400;\">WHERE columnName LIKE \u2018a_%_%\u2019<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns any value that starts with \u2018a\u2019 and is at least 3 characters in length.<\/span><\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td><span style=\"font-weight: 400;\">WHERE columnName LIKE \u2018a%b\u2019<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns any value which starts with \u2018a\u2019 and ends with \u2018b\u2019.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Syntax of SQL Like Operator<\/h3>\n<p>LIKE operator follows the following syntax:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">SELECT col1 as alias1,\r\nCol2 as alias2,\r\nCol3 as alias3,\r\n\u2026\u2026. FROM tableName\r\nWHERE col1 LIKE \u201cpattern\u201d;\r\n<\/pre>\n<p>Here the pattern is the regex expression that we want to be followed by the result of our query.<\/p>\n<h3>Demo Database<\/h3>\n<p>Let us now have a look at the example database of DataFlair which we will be using all along with this tutorial.<\/p>\n<p><strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">USE DataFlair;\r\nSELECT * FROM Dataflair;\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86987\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1.png\" alt=\"SQL Demo Database\" width=\"1920\" height=\"1028\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1-1024x548.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1-768x411.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1-1536x822.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1-520x278.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1-320x171.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Let us now move forward with examples of the LIKE operator.<\/p>\n<p><strong>Example 1:<\/strong> Let us try to find the details of all the employees having &#8216;R\u2019 as the first character in their names.<br \/>\n<strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">USE DataFlair;\r\nSELECT * FROM Dataflair\r\nWHERE name LIKE 'R%';\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-1-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86988\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-1-3.png\" alt=\"SQL Like Operator Example\" width=\"1920\" height=\"1032\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-1-3.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-1-3-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-1-3-1024x550.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-1-3-150x81.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-1-3-768x413.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-1-3-1536x826.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-1-3-720x387.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-1-3-520x280.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-1-3-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><strong>Example 2:<\/strong> Let us try to find the details of all the employees having \u2018i\u2019 as the last character in their names.<br \/>\n<strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">USE DataFlair;\r\nSELECT * FROM Dataflair\r\nWHERE name LIKE '%i';\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-2-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86989\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-2-3.png\" alt=\"SQL Like Clause Example\" width=\"1920\" height=\"1032\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-2-3.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-2-3-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-2-3-1024x550.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-2-3-150x81.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-2-3-768x413.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-2-3-1536x826.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-2-3-720x387.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-2-3-520x280.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-2-3-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><strong>Example 3:<\/strong> Let us try to find the details of all the employees located at offices which have \u2018n\u2019 as a character in them.<br \/>\n<strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">USE DataFlair;\r\nSELECT * FROM Dataflair\r\nWHERE location LIKE '%d%';\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-3-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86991\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-3-3.png\" alt=\"SQL Like Clause\" width=\"1920\" height=\"1032\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-3-3.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-3-3-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-3-3-1024x550.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-3-3-150x81.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-3-3-768x413.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-3-3-1536x826.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-3-3-720x387.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-3-3-520x280.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-3-3-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><strong>Example 4:<\/strong> Let us try to find the details of all the employees having \u2018a\u2019 as the second character in their names and name is 4 characters long.<br \/>\n<strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">USE DataFlair;\r\nSELECT * FROM Dataflair\r\nWHERE name LIKE '_a%__%';\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-4-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86990\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-4-2.png\" alt=\"Like in SQL\" width=\"1920\" height=\"1028\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-4-2.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-4-2-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-4-2-1024x548.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-4-2-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-4-2-768x411.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-4-2-1536x822.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-4-2-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-4-2-520x278.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-4-2-320x171.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><strong>Example 5:<\/strong> Let us try to find the details of all the employees having names starting and ending with \u2018N\u2019.<br \/>\n<strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">USE DataFlair;\r\nSELECT * FROM Dataflair\r\nWHERE name LIKE 'n%N';\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-5-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86992\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-5-2.png\" alt=\"Like Clause in SQL\" width=\"1920\" height=\"1028\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-5-2.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-5-2-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-5-2-1024x548.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-5-2-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-5-2-768x411.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-5-2-1536x822.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-5-2-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-5-2-520x278.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-5-2-320x171.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<h3>Summary<\/h3>\n<p>In this tutorial, we have seen everything about the SQL LIKE operator.<\/p>\n<p>We started with what a Like operator is and what its use cases are. We learnt the regex-like properties of the LIKE operator.<\/p>\n<p>Further we learned the syntax and the rules of the LIKE operator and after this, we moved on to our examples with our exemplar database &#8211; DataFlair.<\/p>\n<p>We have seen how the like operator functions with the wildcards and how we can use it. With the help of the Like operator, we can easily reduce the complexity of our queries.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we will learn about the LIKE logical operator which is used for the wildcards in SQL. Let us now move ahead and understand the syntax and uses of the LIKE operator&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":86986,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[4357,8233,13495,14105],"class_list":["post-24615","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-example-of-sql-like-clause","tag-like-clause-in-sql","tag-sql-like-clause","tag-syntax-of-sql-like-clause"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Like Clause - Syntax and Example - DataFlair<\/title>\n<meta name=\"description\" content=\"SQL Like clause, what is like the clause in SQL, example of SQL Like Clause, SQL Like clause Syntax, Structured Query Language tutorial\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sql-like-clause\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Like Clause - Syntax and Example - DataFlair\" \/>\n<meta property=\"og:description\" content=\"SQL Like clause, what is like the clause in SQL, example of SQL Like Clause, SQL Like clause Syntax, Structured Query Language tutorial\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sql-like-clause\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-15T04:00:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-11T13:32:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/SQL-like-operator.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Like Clause - Syntax and Example - DataFlair","description":"SQL Like clause, what is like the clause in SQL, example of SQL Like Clause, SQL Like clause Syntax, Structured Query Language tutorial","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:\/\/data-flair.training\/blogs\/sql-like-clause\/","og_locale":"en_US","og_type":"article","og_title":"SQL Like Clause - Syntax and Example - DataFlair","og_description":"SQL Like clause, what is like the clause in SQL, example of SQL Like Clause, SQL Like clause Syntax, Structured Query Language tutorial","og_url":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-08-15T04:00:03+00:00","article_modified_time":"2021-03-11T13:32:27+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/SQL-like-operator.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"SQL Like Clause &#8211; Syntax and Example","datePublished":"2018-08-15T04:00:03+00:00","dateModified":"2021-03-11T13:32:27+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/"},"wordCount":582,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/SQL-like-operator.jpg","keywords":["Example of SQL Like Clause","Like Clause in SQL","SQL Like Clause","Syntax of SQL Like clause"],"articleSection":["SQL Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sql-like-clause\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/","url":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/","name":"SQL Like Clause - Syntax and Example - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/SQL-like-operator.jpg","datePublished":"2018-08-15T04:00:03+00:00","dateModified":"2021-03-11T13:32:27+00:00","description":"SQL Like clause, what is like the clause in SQL, example of SQL Like Clause, SQL Like clause Syntax, Structured Query Language tutorial","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sql-like-clause\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/SQL-like-operator.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/SQL-like-operator.jpg","width":1200,"height":628,"caption":"SQL like operator"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sql-like-clause\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Searching for Groups of Scala Regex","item":"https:\/\/data-flair.training\/blogs\/tag\/searching-for-groups-of-scala-regex\/"},{"@type":"ListItem","position":3,"name":"SQL Like Clause &#8211; Syntax and Example"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/24615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=24615"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/24615\/revisions"}],"predecessor-version":[{"id":86993,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/24615\/revisions\/86993"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/86986"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=24615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=24615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=24615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}