{"id":178103,"date":"2023-06-11T14:39:54","date_gmt":"2023-06-11T13:39:54","guid":{"rendered":"https:\/\/datascientest.com\/de\/?p=178103"},"modified":"2023-10-30T11:29:21","modified_gmt":"2023-10-30T10:29:21","slug":"sql-like-so-verwendest-du-die-formel","status":"publish","type":"post","link":"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel","title":{"rendered":"SQL LIKE: So verwendest du die Formel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"178103\" class=\"elementor elementor-178103\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3640ff0 e-flex e-con-boxed e-con\" data-id=\"3640ff0\" 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-2ee1bc8 elementor-widget elementor-widget-heading\" data-id=\"2ee1bc8\" 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\">Um mit Datenbanken zu kommunizieren, k\u00f6nnen Entwickler und Datenexperten die Sprache SQL verwenden. Mithilfe verschiedener Abfragen kannst du bestimmte Informationen ausw\u00e4hlen, eine Tabelle aktualisieren, Daten hinzuf\u00fcgen oder l\u00f6schen usw. Zu den Befehlen, die du kennen solltest, geh\u00f6rt die Abfrage SQL LIKE.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1733c51 elementor-widget elementor-widget-text-editor\" data-id=\"1733c51\" 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>Aber wozu dient sie? Wie kann man sie nutzen? Entdecken Sie die Antworten mit einigen konkreten Anwendungsbeispielen.<\/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-66d8aab e-flex e-con-boxed e-con\" data-id=\"66d8aab\" 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-13ae6a3 elementor-widget elementor-widget-heading\" data-id=\"13ae6a3\" 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 von SQL LIKE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d5820be elementor-widget elementor-widget-text-editor\" data-id=\"d5820be\" 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>Der Befehl SQL LIKE ist einer der unverzichtbaren Befehle der Computersprache <a href=\"https:\/\/datascientest.com\/de\/sql-delete-wie-wird-diese-abfrage-verwendet\">SQL<\/a>. Er dient dazu, innerhalb einer Tabelle nach bestimmten Daten zu suchen. Dazu verwendet LIKE SQL Vorlagen, mit deren Hilfe Sie genau definieren k\u00f6nnen, was Sie brauchen. Wenn Sie beispielsweise Kunden ausw\u00e4hlen m\u00f6chten, deren Namen mit &#8222;de&#8220; beginnen oder mit &#8222;in&#8220; enden, etc.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Auch interessant:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><colgroup><col width=\"268\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;MySQL Relationale Datenbanksoftware&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/mysql-eine-relationale-datenverwaltungssoftware\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/mysql-eine-relationale-datenverwaltungssoftware\" target=\"_blank\" rel=\"noopener\">MySQL Relationale Datenbanksoftware<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Tutorial&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/sql-tutorial\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/sql-tutorial\" target=\"_blank\" rel=\"noopener\">SQL Tutorial<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Apache Cassandra noSQL BDD&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/apache-cassandra-die-beliebteste-nosql-bdd\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/apache-cassandra-die-beliebteste-nosql-bdd\" target=\"_blank\" rel=\"noopener\">Apache Cassandra noSQL BDD<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Joins&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/alles-uber-sql-joins-verstehen\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/alles-uber-sql-joins-verstehen\" target=\"_blank\" rel=\"noopener\">SQL Joins<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Count Tutorial&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/sql-count-unser-tutorial\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/sql-count-unser-tutorial\" target=\"_blank\" rel=\"noopener\">SQL Count Tutorial<\/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-b871923 e-flex e-con-boxed e-con\" data-id=\"b871923\" 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-97d4c47 elementor-widget elementor-widget-heading\" data-id=\"97d4c47\" 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\">Wie wird SQL LIKE verwendet ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-da72097 elementor-widget elementor-widget-text-editor\" data-id=\"da72097\" 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>Um die Abfrage <strong>SQL LIKE<\/strong> zu verwenden, lautet die g\u00e4ngigste Syntax wie folgt:<\/p><ul><li>SELECT *<\/li><li>FROM table<\/li><li>WHERE spalte LIKE modell<\/li><\/ul><p>Mit diesem Befehl kannst du Daten innerhalb einer Tabelle in einer Spalte nach dem durch <strong>SQL LIKE<\/strong> definierten Muster ausw\u00e4hlen. Aber was ist nun dieses Suchmuster?<\/p><p>Es wird durch Jokerzeichen definiert. Diese ersetzen die anderen Zeichen in Ihrer Zeichenkette. Es gibt zwei Haupttypen. N\u00e4mlich:<\/p><p>%: Es steht f\u00fcr alle anderen Zeichen.<br \/>_: steht f\u00fcr ein einzelnes Zeichen.<\/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-0c4d893 elementor-widget elementor-widget-text-editor\" data-id=\"0c4d893\" 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>Davon ausgehend gibt es folgende Kombinationsm\u00f6glichkeiten:<\/p><ul><li>LIKE &#8218;%a&#8216;: Damit kannst du nach allen Zeichenketten suchen, die mit einem &#8222;a&#8220; enden.<\/li><li>LIKE &#8218;a%&#8216;: Umgekehrt kannst du nach allen Zeichenketten suchen, die mit einem &#8222;a&#8220; beginnen.<\/li><li>LIKE &#8218;%a%&#8216;: Dies betrifft alle Datens\u00e4tze, die das Zeichen &#8222;a&#8220; verwenden. Dabei kann das % nur ein, mehrere oder sogar kein Zeichen vor oder nach dem &#8222;a&#8220; anzeigen.<\/li><li>LIKE &#8218;a%ion&#8216;: Mit diesem Muster wird nach Zeichenfolgen gesucht, die mit &#8222;a&#8220; beginnen und mit &#8222;ion&#8220; enden, wie &#8222;Flugzeug&#8220; oder &#8222;Achtung&#8220;.<\/li><li>LIKE &#8218;a__&#8216;: Hierbei wird nach allen Zeichenketten gesucht, die mit &#8222;a&#8220; beginnen. Deren Gesamtanzahl an Zeichen aber auf 3 begrenzt ist.<\/li><li>LIKE &#8218;_a%&#8216;: Die Kombination dieser beiden Wildcards sagt uns, dass die Gesamtzahl der Zeichen keine Rolle spielt. Stattdessen muss das &#8222;a&#8220; unbedingt an zweiter Stelle stehen.<\/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-71ab808 elementor-widget elementor-widget-text-editor\" data-id=\"71ab808\" 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>Damit du die Verwendung von SQL LIKE und die verschiedenen Suchmuster besser verstehen kannst, haben wir einige konkrete Beispiele f\u00fcr dich.<\/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-e9471ba elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e9471ba\" 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\/de\/unsere-aus-und-weiterbildungen\">\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\">SQL LIKE lernen<\/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-a558ae0 e-flex e-con-boxed e-con\" data-id=\"a558ae0\" 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-d220580 elementor-widget elementor-widget-heading\" data-id=\"d220580\" 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 Beispiele f\u00fcr die Verwendung der Abfrage SQL LIKE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5d3f358 elementor-widget elementor-widget-text-editor\" data-id=\"5d3f358\" 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>F\u00fcr diese verschiedenen Beispiele werden wir die folgende &#8222;Client&#8220;-Tabelle verwenden:<\/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-8f6f186 elementor-widget elementor-widget-html\" data-id=\"8f6f186\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 200px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Name<\/th>\r\n    <th class=\"tg-8806\">Vorname<\/th>\r\n    <th class=\"tg-8806\">Postleitzahl<\/th>\r\n    <th class=\"tg-8806\">Telefonnummer<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Annie<\/td>\r\n    <td class=\"tg-c3ow\">75112<\/td>\r\n    <td class=\"tg-c3ow\">06.40.45.36.61<\/td>\r\n    <td class=\"tg-baqh\">annie.m@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Durand<\/td>\r\n    <td class=\"tg-c3ow\">Fabien<\/td>\r\n    <td class=\"tg-c3ow\">17042<\/td>\r\n    <td class=\"tg-c3ow\">07.58.36.21.63<\/td>\r\n    <td class=\"tg-baqh\">fabien.durand@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Dupont<\/td>\r\n    <td class=\"tg-c3ow\">Thomas<\/td>\r\n    <td class=\"tg-c3ow\">17015<\/td>\r\n    <td class=\"tg-c3ow\">06.23.98.51.45<\/td>\r\n    <td class=\"tg-baqh\">dupont17@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Berger<\/td>\r\n    <td class=\"tg-c3ow\">Justine<\/td>\r\n    <td class=\"tg-c3ow\">77485<\/td>\r\n    <td class=\"tg-c3ow\">06.15.29.85.61<\/td>\r\n    <td class=\"tg-baqh\">jusber@orange.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Bernard<\/td>\r\n    <td class=\"tg-c3ow\">Valentin<\/td>\r\n    <td class=\"tg-c3ow\">63950<\/td>\r\n    <td class=\"tg-c3ow\">07.59.65.19.95<\/td>\r\n    <td class=\"tg-baqh\">beber@sfr.fr<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6dccb8c elementor-widget elementor-widget-heading\" data-id=\"6dccb8c\" 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-0b539e8 elementor-widget elementor-widget-text-editor\" data-id=\"0b539e8\" 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>F\u00fcr diesen LIKE SQL-Befehl suchen wir nach allen Kunden, die im D\u00e9partement Charente-Maritime (17) leben. Hier ist die Syntax der Abfrage:<\/p><p>SELECT *<br \/>FROM Kunde<br \/>WHERE Postleitzahl LIKE 77%.<\/p><p>Und hier ist das Ergebnis:<\/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-42b8e34 elementor-widget elementor-widget-html\" data-id=\"42b8e34\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 200px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Name<\/th>\r\n    <th class=\"tg-8806\">Vorname<\/th>\r\n    <th class=\"tg-8806\">Postleitzahl<\/th>\r\n    <th class=\"tg-8806\">Telefonnummer<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Durand<\/td>\r\n    <td class=\"tg-c3ow\">Fabien<\/td>\r\n    <td class=\"tg-c3ow\">17042<\/td>\r\n    <td class=\"tg-c3ow\">07.58.36.21.63<\/td>\r\n    <td class=\"tg-baqh\">fabien.durand@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Dupont<\/td>\r\n    <td class=\"tg-c3ow\">Thomas<\/td>\r\n    <td class=\"tg-c3ow\">17015<\/td>\r\n    <td class=\"tg-c3ow\">06.23.98.51.45<\/td>\r\n    <td class=\"tg-baqh\">dupont17@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-71edded elementor-widget elementor-widget-heading\" data-id=\"71edded\" 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-8aa1892 elementor-widget elementor-widget-text-editor\" data-id=\"8aa1892\" 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>Das Ziel dieser LIKE SQL-Abfrage ist es, alle Kunden mit einer Gmail-Adresse zu finden. Du ben\u00f6tigst dazu folgende Syntax:<\/p><p>SELECT *<br \/>FROM Kunde<br \/>WHERE email LIKE %gmail.com<\/p><p>Und hier ist das Ergebnis:<\/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-984f405 elementor-widget elementor-widget-html\" data-id=\"984f405\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 200px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Vorname<\/th>\r\n    <th class=\"tg-8806\">Nachname<\/th>\r\n    <th class=\"tg-8806\">Postleitzahl<\/th>\r\n    <th class=\"tg-8806\">Telefonnummer<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Annie<\/td>\r\n    <td class=\"tg-c3ow\">75112<\/td>\r\n    <td class=\"tg-c3ow\">06.40.45.36.61<\/td>\r\n    <td class=\"tg-baqh\">annie.m@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Dupont<\/td>\r\n    <td class=\"tg-c3ow\">Thomas<\/td>\r\n    <td class=\"tg-c3ow\">17015<\/td>\r\n    <td class=\"tg-c3ow\">06.23.98.51.45<\/td>\r\n    <td class=\"tg-baqh\">dupont17@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9af7809 elementor-widget elementor-widget-heading\" data-id=\"9af7809\" 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-28a27cc elementor-widget elementor-widget-text-editor\" data-id=\"28a27cc\" 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>Hier suchen wir nach allen Kunden, deren Vorname ein &#8222;i&#8220; enth\u00e4lt. Die Syntax lautet wie folgt:<\/p><p>SELECT *<br \/>FROM Kunde<br \/>WHERE vorname LIKE %i%.<\/p><p>Und hier ist das Ergebnis:<\/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-58d58db elementor-widget elementor-widget-html\" data-id=\"58d58db\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 200px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Name<\/th>\r\n    <th class=\"tg-8806\">Vorname<\/th>\r\n    <th class=\"tg-8806\">Postleitzahl<\/th>\r\n    <th class=\"tg-8806\">Telefonnummer<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Annie<\/td>\r\n    <td class=\"tg-c3ow\">75112<\/td>\r\n    <td class=\"tg-c3ow\">06.40.45.36.61<\/td>\r\n    <td class=\"tg-baqh\">annie.m@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Durand<\/td>\r\n    <td class=\"tg-c3ow\">Fabien<\/td>\r\n    <td class=\"tg-c3ow\">17042<\/td>\r\n    <td class=\"tg-c3ow\">07.58.36.21.63<\/td>\r\n    <td class=\"tg-baqh\">fabien.durand@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Berger<\/td>\r\n    <td class=\"tg-c3ow\">Justine<\/td>\r\n    <td class=\"tg-c3ow\">77485<\/td>\r\n    <td class=\"tg-c3ow\">06.15.29.85.61<\/td>\r\n    <td class=\"tg-baqh\">jusber@orange.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Bernard<\/td>\r\n    <td class=\"tg-c3ow\">Valentin<\/td>\r\n    <td class=\"tg-c3ow\">63950<\/td>\r\n    <td class=\"tg-c3ow\">07.59.65.19.95<\/td>\r\n    <td class=\"tg-baqh\">beber@sfr.fr<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d774c73 elementor-widget elementor-widget-heading\" data-id=\"d774c73\" 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-a01f670 elementor-widget elementor-widget-text-editor\" data-id=\"a01f670\" 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>F\u00fcr diese LIKE SQL-Abfrage suchen wir nach allen Kunden, deren zweiter Buchstabe im Vornamen ein &#8222;ai&#8220; ist. Hier ist die zu verwendende Syntax:<\/p><p>SELECT *<br \/>FROM Kunde<br \/>WHERE vorname LIKE %_a%.<\/p><p>Und hier ist das Ergebnis:<\/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-e5b542a elementor-widget elementor-widget-html\" data-id=\"e5b542a\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 200px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Nachname<\/th>\r\n    <th class=\"tg-8806\">Vorname<\/th>\r\n    <th class=\"tg-8806\">Postleitzahl<\/th>\r\n    <th class=\"tg-8806\">Telefonnummer<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Durand<\/td>\r\n    <td class=\"tg-c3ow\">Fabien<\/td>\r\n    <td class=\"tg-c3ow\">17042<\/td>\r\n    <td class=\"tg-c3ow\">07.58.36.21.63<\/td>\r\n    <td class=\"tg-baqh\">fabien.durand@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Bernard<\/td>\r\n    <td class=\"tg-c3ow\">Valentin<\/td>\r\n    <td class=\"tg-c3ow\">63950<\/td>\r\n    <td class=\"tg-c3ow\">07.59.65.19.95<\/td>\r\n    <td class=\"tg-baqh\">beber@sfr.fr<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d00db92 elementor-widget elementor-widget-heading\" data-id=\"d00db92\" 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-b3ab78c elementor-widget elementor-widget-text-editor\" data-id=\"b3ab78c\" 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>F\u00fcr dieses letzte Beispiel f\u00fcr LIKE SQL suchen wir nach allen Kunden, deren Telefonnummer mit 06 beginnt und mit 61 endet. Die Syntax lautet wie folgt:<\/p><p>SELECT *<br \/>FROM Kunde<br \/>WHERE Telefonnummer LIKE 06%61<\/p><p>Und hier ist das Ergebnis:<\/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-3311105 elementor-widget elementor-widget-html\" data-id=\"3311105\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 200px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Nachname<\/th>\r\n    <th class=\"tg-8806\">Vorname<\/th>\r\n    <th class=\"tg-8806\">Postleitzahl<\/th>\r\n    <th class=\"tg-8806\">Telefonnummer<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Annie<\/td>\r\n    <td class=\"tg-c3ow\">75112<\/td>\r\n    <td class=\"tg-c3ow\">06.40.45.36.61<\/td>\r\n    <td class=\"tg-baqh\">annie.m@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Berger<\/td>\r\n    <td class=\"tg-c3ow\">Justine<\/td>\r\n    <td class=\"tg-c3ow\">77485<\/td>\r\n    <td class=\"tg-c3ow\">06.15.29.85.61<\/td>\r\n    <td class=\"tg-baqh\">jusber@orange.fr<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\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-e0f4487 e-flex e-con-boxed e-con\" data-id=\"e0f4487\" 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-ac3aae2 elementor-widget elementor-widget-heading\" data-id=\"ac3aae2\" 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\">SQL LIKE und mehr lernen mit DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-12446c0 elementor-widget elementor-widget-text-editor\" data-id=\"12446c0\" 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>Neben der LIKE SQL-Abfrage gibt es eine Vielzahl weiterer Abfragen, die du kennen solltest, um effektiv mit <a href=\"https:\/\/datascientest.com\/de\/relationale-datenbanken\">relationalen Datenbanken<\/a> umgehen zu k\u00f6nnen. Wenn du mehr dar\u00fcber erfahren m\u00f6chtest, kannst du an unseren Datentrainings teilnehmen.<\/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-0c2928e elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0c2928e\" 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\/de\/unsere-aus-und-weiterbildungen\">\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\">Entdecke unsere Weiterbildungen<\/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<div class=\"elementor-element elementor-element-13aa216 elementor-widget elementor-widget-html\" data-id=\"13aa216\" 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\": \"D\u00e9finition de LIKE SQL\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"L\u2019op\u00e9rateur LIKE est l\u2019une des commandes incontournables du langage informatique SQL. L\u2019objectif est de rechercher des donn\u00e9es sp\u00e9cifiques au sein d\u2019un tableau. Pour cela, LIKE SQL utilise des mod\u00e8les qui permettent de d\u00e9finir pr\u00e9cis\u00e9ment ce dont vous avez besoin. Par exemple, si vous souhaitez s\u00e9lectionner des clients dont le nom commence par \\\"de\\\" ou termine par \\\"in\\\", etc.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Comment utiliser LIKE SQL ?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Pour utiliser la requ\u00eate LIKE SQL, la syntaxe la plus courante est la suivante : SELECT * , FROM table , WHERE colonne LIKE modele . Gr\u00e2ce \u00e0 cette commande, vous allez pouvoir s\u00e9lectionner des donn\u00e9es au sein d\u2019un tableau, dans une colonne selon le mod\u00e8le d\u00e9fini par LIKE SQL. Mais alors quel est ce mod\u00e8le de recherche ?\"\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>Um mit Datenbanken zu kommunizieren, k\u00f6nnen Entwickler und Datenexperten die Sprache SQL verwenden. Mithilfe verschiedener Abfragen kannst du bestimmte Informationen ausw\u00e4hlen, eine Tabelle aktualisieren, Daten hinzuf\u00fcgen oder l\u00f6schen usw. Zu den Befehlen, die du kennen solltest, geh\u00f6rt die Abfrage SQL LIKE. Aber wozu dient sie? Wie kann man sie nutzen? Entdecken Sie die Antworten mit [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":178106,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2454],"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>SQL LIKE: So verwendest du die Formel<\/title>\n<meta name=\"description\" content=\"In SQL kann der LIKE-Operator verwendet werden, um nach Zeichenfolgen zu suchen, die eine bestimmte Bedingung erf\u00fcllen. Der SQL LIKE...\" \/>\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\/de\/sql-like-so-verwendest-du-die-formel\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL LIKE: So verwendest du die Formel\" \/>\n<meta property=\"og:description\" content=\"Um mit Datenbanken zu kommunizieren, k\u00f6nnen Entwickler und Datenexperten die Sprache SQL verwenden. Mithilfe verschiedener Abfragen kannst du bestimmte\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel\" \/>\n<meta property=\"og:site_name\" content=\"Weiterbildung Data Science | DataScientest.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-11T13:39:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-30T10:29:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2023\/06\/like-sql-datascientest.webp\" \/>\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\/webp\" \/>\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=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"SQL LIKE: So verwendest du die Formel\",\"datePublished\":\"2023-06-11T13:39:54+00:00\",\"dateModified\":\"2023-10-30T10:29:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel\"},\"wordCount\":765,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/de\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel\",\"url\":\"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel\",\"name\":\"SQL LIKE: So verwendest du die Formel\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/de\/#website\"},\"datePublished\":\"2023-06-11T13:39:54+00:00\",\"dateModified\":\"2023-10-30T10:29:21+00:00\",\"description\":\"In SQL kann der LIKE-Operator verwendet werden, um nach Zeichenfolgen zu suchen, die eine bestimmte Bedingung erf\u00fcllen. Der SQL LIKE...\",\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/de\/#website\",\"url\":\"https:\/\/datascientest.com\/de\/\",\"name\":\"Weiterbildung Data Science | DataScientest.com\",\"description\":\"F\u00fchrender Anbieter von Schulungen im Bereich Data Science\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/de\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/de\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/company\/datascientest-germany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/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\/de\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL LIKE: So verwendest du die Formel","description":"In SQL kann der LIKE-Operator verwendet werden, um nach Zeichenfolgen zu suchen, die eine bestimmte Bedingung erf\u00fcllen. Der SQL LIKE...","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\/de\/sql-like-so-verwendest-du-die-formel","og_locale":"de_DE","og_type":"article","og_title":"SQL LIKE: So verwendest du die Formel","og_description":"Um mit Datenbanken zu kommunizieren, k\u00f6nnen Entwickler und Datenexperten die Sprache SQL verwenden. Mithilfe verschiedener Abfragen kannst du bestimmte","og_url":"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel","og_site_name":"Weiterbildung Data Science | DataScientest.com","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-06-11T13:39:54+00:00","article_modified_time":"2023-10-30T10:29:21+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2023\/06\/like-sql-datascientest.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Verfasst von":"Melanie","Gesch\u00e4tzte Lesezeit":"5 Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel#article","isPartOf":{"@id":"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"SQL LIKE: So verwendest du die Formel","datePublished":"2023-06-11T13:39:54+00:00","dateModified":"2023-10-30T10:29:21+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel"},"wordCount":765,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/de\/#organization"},"articleSection":["Data Science"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel","url":"https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel","name":"SQL LIKE: So verwendest du die Formel","isPartOf":{"@id":"https:\/\/datascientest.com\/de\/#website"},"datePublished":"2023-06-11T13:39:54+00:00","dateModified":"2023-10-30T10:29:21+00:00","description":"In SQL kann der LIKE-Operator verwendet werden, um nach Zeichenfolgen zu suchen, die eine bestimmte Bedingung erf\u00fcllen. Der SQL LIKE...","inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/de\/sql-like-so-verwendest-du-die-formel"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/de\/#website","url":"https:\/\/datascientest.com\/de\/","name":"Weiterbildung Data Science | DataScientest.com","description":"F\u00fchrender Anbieter von Schulungen im Bereich Data Science","publisher":{"@id":"https:\/\/datascientest.com\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/de\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/de\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/company\/datascientest-germany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/datascientest.com\/de\/#\/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\/de\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts\/178103"}],"collection":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/comments?post=178103"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts\/178103\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/media\/178106"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/media?parent=178103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/categories?post=178103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/tags?post=178103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}