{"id":171965,"date":"2023-10-15T12:07:52","date_gmt":"2023-10-15T11:07:52","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=171965"},"modified":"2023-11-10T11:31:44","modified_gmt":"2023-11-10T10:31:44","slug":"like-sql-how-to-use-this-search-function","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function","title":{"rendered":"LIKE SQL: How to use this search function"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"171965\" class=\"elementor elementor-171965\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-326f30f e-flex e-con-boxed e-con\" data-id=\"326f30f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d009764 elementor-widget elementor-widget-heading\" data-id=\"d009764\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Developers and data experts can use SQL to communicate with databases. Thanks to various queries, you can select certain information, update a table, add data, delete data, and so on. Among the commands you need to know is the LIKE SQL query.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-df9ee83 elementor-widget elementor-widget-text-editor\" data-id=\"df9ee83\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>But what is it used for? How do you use it? Discover the answers with a few examples of concrete applications.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e98543a e-flex e-con-boxed e-con\" data-id=\"e98543a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-667779e elementor-widget elementor-widget-heading\" data-id=\"667779e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Definition of LIKE SQL<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5cbd37c elementor-widget elementor-widget-text-editor\" data-id=\"5cbd37c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The LIKE operator is one of the essential commands of the <a href=\"https:\/\/datascientest.com\/en\/sql-learn-all-about-the-programming-language-for-databases\">SQL computer language<\/a>. Its purpose is to search for specific data within a table. To achieve this, LIKE SQL uses templates to define exactly what you need. For example, if you want to select customers whose names start with &#8220;de&#8221; or end with &#8220;in&#8221;, etc., you can use the &#8220;in&#8221; and &#8220;out&#8221; patterns.<\/p><p>\u00a0<\/p><p><span data-sheets-formula-bar-text-style=\"font-size:10px;color:#000000;font-weight:normal;text-decoration:none;font-family:'Arial';font-style:normal;text-decoration-skip-ink:none;\">\ud83d\udca1<\/span>Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL DELETE: How do I use this query?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\" target=\"_blank\" rel=\"noopener\">SQL DELETE: How do I use this query?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Developer: What is it? What's it for?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\" target=\"_blank\" rel=\"noopener\">SQL Developer: What is it? What&#8217;s it for?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Tutorial: Top 5 Most Useful Methods&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\" target=\"_blank\" rel=\"noopener\">SQL Tutorial: Top 5 Most Useful Methods<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL joins: everything you need to know about table associations&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\" target=\"_blank\" rel=\"noopener\">SQL joins: everything you need to know about table associations<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL vs NoSQL: differences, uses, advantages and disadvantages&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\" target=\"_blank\" rel=\"noopener\">SQL vs NoSQL: differences, uses, advantages and disadvantages<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;NoSQL: All about non-relational databases&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\" target=\"_blank\" rel=\"noopener\">NoSQL: All about non-relational databases<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9caddbf e-flex e-con-boxed e-con\" data-id=\"9caddbf\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-31837e9 elementor-widget elementor-widget-heading\" data-id=\"31837e9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I use LIKE SQL?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-32570cb elementor-widget elementor-widget-text-editor\" data-id=\"32570cb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To use the<strong> LIKE SQL query,<\/strong> the most common syntax is as follows:<\/p><p>SELECT *<br \/>FROM table<br \/>WHERE column LIKE model<\/p><p>With this command, you can select data within a table, in a column, according to the model <a href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\">defined by LIKE SQL. But what is this search pattern?<\/a><\/p><p>It&#8217;s defined by wildcards. These replace the other characters in your string. There are two main wildcards. These are :<\/p><p>%: represents all other characters.<br \/>_: represents a single character.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1688659 elementor-widget elementor-widget-text-editor\" data-id=\"1688659\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>From there, here are the possible combinations:<\/p><ul><li>LIKE &#8216;%a&#8217;: allows you to search for all strings ending in &#8220;a&#8221;.<\/li><li>LIKE &#8216;a%&#8217;: conversely, you can search for all strings beginning with &#8220;a&#8221;.<\/li><li>LIKE &#8216;%a%&#8217;: this concerns all records that use the &#8220;a&#8221; character. In this case, the % may indicate only one, several or even no character before or after the &#8220;a&#8221;.<\/li><li>LIKE &#8216;a%ion&#8217;: this pattern searches for strings starting with &#8220;a&#8221; and ending with &#8220;ion&#8221;, such as &#8220;airplane&#8221; or &#8220;attention&#8221;.<\/li><li>LIKE &#8216;a__&#8217;: this searches for all strings beginning with &#8220;a&#8221;. But the total number of characters is limited to 3.<\/li><li>LIKE &#8216;_a%&#8217;: the combination of these two wildcards tells us that the total number of characters doesn&#8217;t matter. However, the &#8220;a&#8221; must be placed in the second position.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41703bf elementor-widget elementor-widget-text-editor\" data-id=\"41703bf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To help you better understand the use of LIKE SQL and its various search models, we&#8217;ve provided a number of concrete examples.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dcebe6d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"dcebe6d\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn to use LIKE SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-43c2cf6 e-flex e-con-boxed e-con\" data-id=\"43c2cf6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5fe43c3 elementor-widget elementor-widget-heading\" data-id=\"5fe43c3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I use LIKE SQL?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-06dd4bf elementor-widget elementor-widget-text-editor\" data-id=\"06dd4bf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To use the LIKE SQL query, the most common syntax is as follows:<\/p><p>SELECT *<br \/>FROM table<br \/>WHERE column LIKE model<\/p><p>With this command, you can select data within a table, in a column, according to the model defined by LIKE SQL. But what is this search pattern?<\/p><p>It&#8217;s defined by wildcards. These replace the other characters in your string. There are two main wildcards. These are :<\/p><p>%: represents all other characters.<br \/>_: represents a single character.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-80f4527 elementor-widget elementor-widget-text-editor\" data-id=\"80f4527\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>From there, here are the possible combinations:<\/p><ul><li>LIKE &#8216;%a&#8217;: allows you to search for all strings ending in &#8220;a&#8221;.<\/li><li>LIKE &#8216;a%&#8217;: conversely, you can search for all strings beginning with &#8220;a&#8221;.<\/li><li>LIKE &#8216;%a%&#8217;: this concerns all records that use the &#8220;a&#8221; character. In this case, the % may indicate only one, several or even no character before or after the &#8220;a&#8221;.<\/li><li>LIKE &#8216;a%ion&#8217;: this pattern searches for strings starting with &#8220;a&#8221; and ending with &#8220;ion&#8221;, such as &#8220;airplane&#8221; or &#8220;attention&#8221;.<\/li><li>LIKE &#8216;a__&#8217;: this searches for all strings beginning with &#8220;a&#8221;. But the total number of characters is limited to 3.<\/li><li>LIKE &#8216;_a%&#8217;: the combination of these two wildcards tells us that the total number of characters doesn&#8217;t matter. However, the &#8220;a&#8221; must be placed in the second position.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e6201e elementor-widget elementor-widget-text-editor\" data-id=\"7e6201e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To help you better understand the use of LIKE SQL and its various search models, we&#8217;ve provided a number of concrete examples.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c5702b5 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"c5702b5\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn more about LIKE SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e834355 e-flex e-con-boxed e-con\" data-id=\"e834355\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-fd18474 elementor-widget elementor-widget-heading\" data-id=\"fd18474\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">5 examples of using the SQL LIKE query <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-87d1332 elementor-widget elementor-widget-text-editor\" data-id=\"87d1332\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>For these examples, we will use the &#8220;Customer&#8221; table below:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d45edae elementor-widget elementor-widget-html\" data-id=\"d45edae\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\n<colgroup>\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 200px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">Last Name<\/th>\n    <th class=\"tg-8806\">First Name<\/th>\n    <th class=\"tg-8806\">Postal Code<\/th>\n    <th class=\"tg-8806\">Phone Number<\/th>\n    <th class=\"tg-mw77\">Email<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Annie<\/td>\n    <td class=\"tg-c3ow\">75112<\/td>\n    <td class=\"tg-c3ow\">06.40.45.36.61<\/td>\n    <td class=\"tg-baqh\">annie.m@gmail.com<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Durand<\/td>\n    <td class=\"tg-c3ow\">Fabien<\/td>\n    <td class=\"tg-c3ow\">17042<\/td>\n    <td class=\"tg-c3ow\">07.58.36.21.63<\/td>\n    <td class=\"tg-baqh\">fabien.durand@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Dupont<\/td>\n    <td class=\"tg-c3ow\">Thomas<\/td>\n    <td class=\"tg-c3ow\">17015<\/td>\n    <td class=\"tg-c3ow\">06.23.98.51.45<\/td>\n    <td class=\"tg-baqh\">dupont17@gmail.com<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Berger<\/td>\n    <td class=\"tg-c3ow\">Justine<\/td>\n    <td class=\"tg-c3ow\">77485<\/td>\n    <td class=\"tg-c3ow\">06.15.29.85.61<\/td>\n    <td class=\"tg-baqh\">jusber@orange.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Bernard<\/td>\n    <td class=\"tg-c3ow\">Valentin<\/td>\n    <td class=\"tg-c3ow\">63950<\/td>\n    <td class=\"tg-c3ow\">07.59.65.19.95<\/td>\n    <td class=\"tg-baqh\">beber@sfr.fr<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee89385 elementor-widget elementor-widget-heading\" data-id=\"ee89385\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">LIKE \u2018a%\u2019 <\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a80815c elementor-widget elementor-widget-text-editor\" data-id=\"a80815c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>For this LIKE SQL command, we&#8217;re looking for all customers living in the Charente-Maritime department (17). Here&#8217;s the query syntax:<\/p><p>SELECT *<br \/>FROM Customer<br \/>WHERE Postal code LIKE 77%<\/p><p>And here&#8217;s the result:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-49807a7 elementor-widget elementor-widget-html\" data-id=\"49807a7\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\n<colgroup>\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 200px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">Last Name<\/th>\n    <th class=\"tg-8806\">First Name<\/th>\n    <th class=\"tg-8806\">Postal Code<\/th>\n    <th class=\"tg-8806\">Phone Number<\/th>\n    <th class=\"tg-mw77\">Email<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-c3ow\">Durand<\/td>\n    <td class=\"tg-c3ow\">Fabien<\/td>\n    <td class=\"tg-c3ow\">17042<\/td>\n    <td class=\"tg-c3ow\">07.58.36.21.63<\/td>\n    <td class=\"tg-baqh\">fabien.durand@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Dupont<\/td>\n    <td class=\"tg-c3ow\">Thomas<\/td>\n    <td class=\"tg-c3ow\">17015<\/td>\n    <td class=\"tg-c3ow\">06.23.98.51.45<\/td>\n    <td class=\"tg-baqh\">dupont17@gmail.com<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c9005b7 elementor-widget elementor-widget-heading\" data-id=\"c9005b7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">LIKE \u2018a%\u2019<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c7252d1 elementor-widget elementor-widget-text-editor\" data-id=\"c7252d1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The aim of this LIKE SQL query is to find all customers with a Gmail address. You&#8217;ll need this syntax:<\/p><p>SELECT *<br \/>FROM Customer<br \/>WHERE email LIKE %gmail.com<\/p><p>And here&#8217;s the result:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bacf8a4 elementor-widget elementor-widget-html\" data-id=\"bacf8a4\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\n<colgroup>\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 200px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">Last Name<\/th>\n    <th class=\"tg-8806\">First Name<\/th>\n    <th class=\"tg-8806\">Postal Code<\/th>\n    <th class=\"tg-8806\">Phone Number<\/th>\n    <th class=\"tg-mw77\">Email<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Annie<\/td>\n    <td class=\"tg-c3ow\">75112<\/td>\n    <td class=\"tg-c3ow\">06.40.45.36.61<\/td>\n    <td class=\"tg-baqh\">annie.m@gmail.com<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Dupont<\/td>\n    <td class=\"tg-c3ow\">Thomas<\/td>\n    <td class=\"tg-c3ow\">17015<\/td>\n    <td class=\"tg-c3ow\">06.23.98.51.45<\/td>\n    <td class=\"tg-baqh\">dupont17@gmail.com<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7da2bce elementor-widget elementor-widget-heading\" data-id=\"7da2bce\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">LIKE \u2018%a%\u2019<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a97757d elementor-widget elementor-widget-text-editor\" data-id=\"a97757d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Here, we&#8217;re looking for all customers whose first name contains an &#8220;i&#8221;. The syntax is as follows:<\/p><p>SELECT *<br \/>FROM Customer<br \/>WHERE first name LIKE %i%<\/p><p>And here&#8217;s the result:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b7fe201 elementor-widget elementor-widget-html\" data-id=\"b7fe201\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\n<colgroup>\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 200px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">Last Name<\/th>\n    <th class=\"tg-8806\">First Name<\/th>\n    <th class=\"tg-8806\">Postal Code<\/th>\n    <th class=\"tg-8806\">Phone Number<\/th>\n    <th class=\"tg-mw77\">Email<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Annie<\/td>\n    <td class=\"tg-c3ow\">75112<\/td>\n    <td class=\"tg-c3ow\">06.40.45.36.61<\/td>\n    <td class=\"tg-baqh\">annie.m@gmail.com<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Durand<\/td>\n    <td class=\"tg-c3ow\">Fabien<\/td>\n    <td class=\"tg-c3ow\">17042<\/td>\n    <td class=\"tg-c3ow\">07.58.36.21.63<\/td>\n    <td class=\"tg-baqh\">fabien.durand@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Berger<\/td>\n    <td class=\"tg-c3ow\">Justine<\/td>\n    <td class=\"tg-c3ow\">77485<\/td>\n    <td class=\"tg-c3ow\">06.15.29.85.61<\/td>\n    <td class=\"tg-baqh\">jusber@orange.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Bernard<\/td>\n    <td class=\"tg-c3ow\">Valentin<\/td>\n    <td class=\"tg-c3ow\">63950<\/td>\n    <td class=\"tg-c3ow\">07.59.65.19.95<\/td>\n    <td class=\"tg-baqh\">beber@sfr.fr<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f8ffe90 elementor-widget elementor-widget-heading\" data-id=\"f8ffe90\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">LIKE \u2018_a%\u2019<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4878c73 elementor-widget elementor-widget-text-editor\" data-id=\"4878c73\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>For this LIKE SQL query, we&#8217;re looking for all customers whose second letter in their first name is an &#8220;ai&#8221;. Here&#8217;s the syntax to use:<\/p><p>SELECT *<br \/>FROM Customer<br \/>WHERE first name LIKE %_a%<\/p><p>And here&#8217;s the result:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c8c4374 elementor-widget elementor-widget-html\" data-id=\"c8c4374\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\n<colgroup>\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 200px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">Last Name<\/th>\n    <th class=\"tg-8806\">First Name<\/th>\n    <th class=\"tg-8806\">Postal Code<\/th>\n    <th class=\"tg-8806\">Phone Number<\/th>\n    <th class=\"tg-mw77\">Email<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-c3ow\">Durand<\/td>\n    <td class=\"tg-c3ow\">Fabien<\/td>\n    <td class=\"tg-c3ow\">17042<\/td>\n    <td class=\"tg-c3ow\">07.58.36.21.63<\/td>\n    <td class=\"tg-baqh\">fabien.durand@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Bernard<\/td>\n    <td class=\"tg-c3ow\">Valentin<\/td>\n    <td class=\"tg-c3ow\">63950<\/td>\n    <td class=\"tg-c3ow\">07.59.65.19.95<\/td>\n    <td class=\"tg-baqh\">beber@sfr.fr<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2d8fb96 elementor-widget elementor-widget-heading\" data-id=\"2d8fb96\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">LIKE \u2018a%ion\u2019<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f57ce7 elementor-widget elementor-widget-text-editor\" data-id=\"3f57ce7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>For this last LIKE SQL example, we&#8217;re looking for all customers whose phone number starts with 06 and ends with 61. The syntax is as follows:<\/p><p>SELECT *<br \/>FROM Customer<br \/>WHERE phone number LIKE 06%61<\/p><p>And here&#8217;s the result:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ddc49fe elementor-widget elementor-widget-html\" data-id=\"ddc49fe\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\n<colgroup>\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 200px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">Last Name<\/th>\n    <th class=\"tg-8806\">First Name<\/th>\n    <th class=\"tg-8806\">Postal Code<\/th>\n    <th class=\"tg-8806\">Phone Number<\/th>\n    <th class=\"tg-mw77\">Email<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Annie<\/td>\n    <td class=\"tg-c3ow\">75112<\/td>\n    <td class=\"tg-c3ow\">06.40.45.36.61<\/td>\n    <td class=\"tg-baqh\">annie.m@gmail.com<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Berger<\/td>\n    <td class=\"tg-c3ow\">Justine<\/td>\n    <td class=\"tg-c3ow\">77485<\/td>\n    <td class=\"tg-c3ow\">06.15.29.85.61<\/td>\n    <td class=\"tg-baqh\">jusber@orange.fr<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6117ee4 e-flex e-con-boxed e-con\" data-id=\"6117ee4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c0b9fa2 elementor-widget elementor-widget-html\" data-id=\"c0b9fa2\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"SQL LIKE definition\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The LIKE operator is one of the essential commands of the SQL computer language. Its purpose is to search for specific data within a table. To achieve this, LIKE SQL uses templates to define exactly what you need. For example, if you want to select customers whose names start with \"de\" or end with \"in\", etc.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How do I use LIKE SQL?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"To use the LIKE SQL query, the most common syntax is as follows: SELECT * , FROM table , WHERE column LIKE modele . With this command, you'll be able to select data within a table, in a column according to the model defined by LIKE SQL. But what is this search model?\"\n    }\n  }]\n}\n<\/script\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Developers and data experts can use SQL to communicate with databases. Thanks to various queries, you can select certain information, update a table, add data, delete data, and so on. Among the commands you need to know is the LIKE SQL query. But what is it used for? How do you use it? Discover the [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":171968,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>LIKE SQL: How to use this search function<\/title>\n<meta name=\"description\" content=\"Discover effective tips for improving your productivity and achieving your goals with the LIKE SQL command as ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LIKE SQL: How to use this search function\" \/>\n<meta property=\"og:description\" content=\"Developers and data experts can use SQL to communicate with databases. Thanks to various queries, you can select certain information, update a table, add\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-15T11:07:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-10T10:31:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/10\/like-sql-datascientest-1024x512-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"LIKE SQL: How to use this search function\",\"datePublished\":\"2023-10-15T11:07:52+00:00\",\"dateModified\":\"2023-11-10T10:31:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function\"},\"wordCount\":1006,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function\",\"url\":\"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function\",\"name\":\"LIKE SQL: How to use this search function\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-10-15T11:07:52+00:00\",\"dateModified\":\"2023-11-10T10:31:44+00:00\",\"description\":\"Discover effective tips for improving your productivity and achieving your goals with the LIKE SQL command as ...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"LIKE SQL: How to use this search function","description":"Discover effective tips for improving your productivity and achieving your goals with the LIKE SQL command as ...","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:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function","og_locale":"en_GB","og_type":"article","og_title":"LIKE SQL: How to use this search function","og_description":"Developers and data experts can use SQL to communicate with databases. Thanks to various queries, you can select certain information, update a table, add","og_url":"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-10-15T11:07:52+00:00","article_modified_time":"2023-11-10T10:31:44+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2023\/10\/like-sql-datascientest-1024x512-1.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"LIKE SQL: How to use this search function","datePublished":"2023-10-15T11:07:52+00:00","dateModified":"2023-11-10T10:31:44+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function"},"wordCount":1006,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function","url":"https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function","name":"LIKE SQL: How to use this search function","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-10-15T11:07:52+00:00","dateModified":"2023-11-10T10:31:44+00:00","description":"Discover effective tips for improving your productivity and achieving your goals with the LIKE SQL command as ...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/like-sql-how-to-use-this-search-function"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/171965"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=171965"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/171965\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/171968"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=171965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=171965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=171965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}