{"id":199794,"date":"2023-06-01T07:00:00","date_gmt":"2023-06-01T07:00:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=199794"},"modified":"2023-11-09T13:52:18","modified_gmt":"2023-11-09T13:52:18","slug":"like-sql-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/like-sql-tout-savoir","title":{"rendered":"LIKE SQL : Comment utiliser cette fonction de recherche ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"199794\" class=\"elementor elementor-199794\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f273de3 e-flex e-con-boxed e-con\" data-id=\"f273de3\" 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-6c245fe elementor-widget elementor-widget-heading\" data-id=\"6c245fe\" 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\">Afin de communiquer avec les bases de donn\u00e9es, les d\u00e9veloppeurs et experts data peuvent utiliser le langage SQL. Gr\u00e2ce \u00e0 diff\u00e9rentes requ\u00eates, vous pouvez s\u00e9lectionner certaines informations, mettre \u00e0 jour un tableau, ajouter des donn\u00e9es, en supprimer, etc. Parmi les commandes \u00e0 conna\u00eetre, il y a la requ\u00eate LIKE SQL.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5765e11 elementor-widget elementor-widget-text-editor\" data-id=\"5765e11\" 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>Mais \u00e0 quoi sert-elle ? Comment l\u2019utiliser ? D\u00e9couvrez les r\u00e9ponses avec quelques exemples d\u2019applications concr\u00e8tes.<\/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-c7dc07f e-flex e-con-boxed e-con\" data-id=\"c7dc07f\" 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-f8d55b8 elementor-widget elementor-widget-heading\" data-id=\"f8d55b8\" 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\">D\u00e9finition de LIKE SQL<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c5fd499 elementor-widget elementor-widget-text-editor\" data-id=\"c5fd499\" 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>L\u2019op\u00e9rateur LIKE est l\u2019une des commandes incontournables du <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">langage informatique SQL<\/a>. L\u2019objectif est de <strong>rechercher des donn\u00e9es sp\u00e9cifiques au sein d\u2019un tableau<\/strong>. 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 \u00ab\u00a0de\u00a0\u00bb ou termine par \u00ab\u00a0in\u00a0\u00bb, etc. <\/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-95bfeb4 e-flex e-con-boxed e-con\" data-id=\"95bfeb4\" 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-81b65a1 elementor-widget elementor-widget-heading\" data-id=\"81b65a1\" 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\">Comment utiliser LIKE SQL ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-88e10dc elementor-widget elementor-widget-text-editor\" data-id=\"88e10dc\" 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>Pour utiliser la requ\u00eate LIKE SQL, la syntaxe la plus courante est la suivante : <\/p><p style=\"padding-left: 40px;\">SELECT *<br \/>FROM table<br \/>WHERE colonne LIKE modele<\/p><p>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 ? <\/p><p>Il est d\u00e9fini par des caract\u00e8res joker. Ces derniers se substituent aux autres caract\u00e8res de votre cha\u00eene de caract\u00e8re. Il en existe deux principaux. \u00c0 savoir : <\/p><ul><li>% : il repr\u00e9sente tous les autres caract\u00e8res. <\/li><li>_ : il repr\u00e9sente un seul caract\u00e8re.<\/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-35ef2c8 elementor-widget elementor-widget-text-editor\" data-id=\"35ef2c8\" 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>\u00c0 partir de l\u00e0, voici les diff\u00e9rentes combinaisons possibles : <\/p><ul><li><strong>LIKE \u2018%a\u2019<\/strong> : il vous permet de rechercher toutes les cha\u00eenes de caract\u00e8res qui se terminent par un \u00ab\u00a0a\u00a0\u00bb.<\/li><li><strong>LIKE \u2018a%\u2019<\/strong> : \u00e0 l\u2019inverse, vous pouvez rechercher toutes les cha\u00eenes de caract\u00e8re qui commencent par un \u00ab\u00a0a\u00a0\u00bb.<\/li><li><strong>LIKE \u2018%a%\u2019<\/strong> : cela concerne tous les enregistrements qui utilisent le caract\u00e8re \u00ab\u00a0a\u00a0\u00bb. Dans ce cadre, le % peut n\u2019indiquer qu\u2019un seul, plusieurs ou m\u00eame aucun caract\u00e8re ant\u00e9rieur ou post\u00e9rieur au \u00ab\u00a0a\u00a0\u00bb.<\/li><li><strong>LIKE \u2018a%ion\u2019<\/strong> : ce mod\u00e8le permet de rechercher les cha\u00eenes de caract\u00e8re qui commencent par \u00ab\u00a0a\u00a0\u00bb et qui se terminent par \u00ab\u00a0ion\u00a0\u00bb, comme \u00ab\u00a0avion\u00a0\u00bb ou \u00ab\u00a0attention\u00a0\u00bb.<\/li><li><strong>LIKE \u2018a__\u2019<\/strong> : il s\u2019agit de rechercher toutes les cha\u00eenes de caract\u00e8res commen\u00e7ant par \u00ab\u00a0a\u00a0\u00bb. Mais dont le nombre total de caract\u00e8res est limit\u00e9 \u00e0 3. <\/li><li><strong>LIKE \u2018_a%\u2019<\/strong> : la combinaison de ces deux jokers nous indique que le nombre de caract\u00e8res total n\u2019importe pas. En revanche, le \u00ab\u00a0a\u00a0\u00bb doit imp\u00e9rativement \u00eatre plac\u00e9 en seconde 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-9a5c571 elementor-widget elementor-widget-text-editor\" data-id=\"9a5c571\" 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>Pour vous aider \u00e0 mieux comprendre l\u2019utilisation de LIKE SQL et de ses diff\u00e9rents mod\u00e8les de recherche, nous vous proposons plusieurs exemples concrets.<\/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-d10a801 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"d10a801\" 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\/formation-sql\">\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\">Apprendre \u00e0 utiliser 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-d2beac9 e-flex e-con-boxed e-con\" data-id=\"d2beac9\" 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-85dce39 elementor-widget elementor-widget-heading\" data-id=\"85dce39\" 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 exemples d\u2019utilisation de la requ\u00eate SQL LIKE <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e077a65 elementor-widget elementor-widget-text-editor\" data-id=\"e077a65\" 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>Pour ces diff\u00e9rents exemples, nous allons utiliser le tableau \u00ab\u00a0Client\u00a0\u00bb ci-dessous :<\/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-2c31572 elementor-widget elementor-widget-html\" data-id=\"2c31572\" 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\">Nom<\/th>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Code postal<\/th>\r\n    <th class=\"tg-8806\">Num\u00e9ro de t\u00e9l\u00e9phone<\/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-d53dc3f elementor-widget elementor-widget-heading\" data-id=\"d53dc3f\" 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-7bab05a elementor-widget elementor-widget-text-editor\" data-id=\"7bab05a\" 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>Pour cette commande LIKE SQL, nous recherchons tous les clients vivant dans le d\u00e9partement Charente-Maritime (17). Voici la syntaxe de la requ\u00eate : <\/p><p style=\"padding-left: 40px;\">SELECT *<br \/>FROM Client<br \/>WHERE Code postal LIKE 77%<\/p><p>Et voici le r\u00e9sultat : <\/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-9c5d18e elementor-widget elementor-widget-html\" data-id=\"9c5d18e\" 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\">Nom<\/th>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Code postal<\/th>\r\n    <th class=\"tg-8806\">Num\u00e9ro de t\u00e9l\u00e9phone<\/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-2debd44 elementor-widget elementor-widget-heading\" data-id=\"2debd44\" 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-8d34ba7 elementor-widget elementor-widget-text-editor\" data-id=\"8d34ba7\" 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>L\u2019objectif de cette requ\u00eate LIKE SQL est de rechercher tous les clients ayant une adresse Gmail. Vous aurez besoin de cette syntaxe : <\/p><p style=\"padding-left: 40px;\">SELECT *<br \/>FROM Client<br \/>WHERE email LIKE %gmail.com<\/p><p>Et voici le r\u00e9sultat : <\/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-40f60a4 elementor-widget elementor-widget-html\" data-id=\"40f60a4\" 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\">Nom<\/th>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Code postal<\/th>\r\n    <th class=\"tg-8806\">Num\u00e9ro de t\u00e9l\u00e9phone<\/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-6fb07ce elementor-widget elementor-widget-heading\" data-id=\"6fb07ce\" 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-9bce23d elementor-widget elementor-widget-text-editor\" data-id=\"9bce23d\" 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>Ici, nous recherchons tous les clients dont le pr\u00e9nom contient un \u00ab\u00a0i\u00a0\u00bb. La syntaxe est la suivante : <\/p><p style=\"padding-left: 40px;\">SELECT *<br \/>FROM Client<br \/>WHERE pr\u00e9nom LIKE %i%<\/p><p>Et voici le r\u00e9sultat : <\/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-0e7c720 elementor-widget elementor-widget-html\" data-id=\"0e7c720\" 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\">Nom<\/th>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Code postal<\/th>\r\n    <th class=\"tg-8806\">Num\u00e9ro de t\u00e9l\u00e9phone<\/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-a1899e9 elementor-widget elementor-widget-heading\" data-id=\"a1899e9\" 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-9089525 elementor-widget elementor-widget-text-editor\" data-id=\"9089525\" 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>Pour cette requ\u00eate LIKE SQL, nous recherchons tous les clients dont la deuxi\u00e8me lettre du pr\u00e9nom est un \u00ab\u00a0ai\u00a0\u00bb. Voici la syntaxe \u00e0 utiliser : <\/p><p style=\"padding-left: 40px;\">SELECT *<br \/>FROM Client<br \/>WHERE pr\u00e9nom LIKE %_a%<\/p><p>Et voici le r\u00e9sultat :<\/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-6bc0e0c elementor-widget elementor-widget-html\" data-id=\"6bc0e0c\" 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\">Nom<\/th>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Code postal<\/th>\r\n    <th class=\"tg-8806\">Num\u00e9ro de t\u00e9l\u00e9phone<\/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-b1cc089 elementor-widget elementor-widget-heading\" data-id=\"b1cc089\" 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-3450966 elementor-widget elementor-widget-text-editor\" data-id=\"3450966\" 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>Pour ce dernier exemple de LIKE SQL, nous recherchons tous les clients dont le num\u00e9ro de t\u00e9l\u00e9phone comment par 06 et termine par 61. La syntaxe est la suivante : <\/p><p style=\"padding-left: 40px;\">SELECT *<br \/>FROM Client<br \/>WHERE num\u00e9ro de t\u00e9l\u00e9phone LIKE 06%61<\/p><p>Et voici le r\u00e9sultat :<\/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-1d70876 elementor-widget elementor-widget-html\" data-id=\"1d70876\" 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\">Nom<\/th>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Code postal<\/th>\r\n    <th class=\"tg-8806\">Num\u00e9ro de t\u00e9l\u00e9phone<\/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-08454d1 e-flex e-con-boxed e-con\" data-id=\"08454d1\" 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-b77da80 elementor-widget elementor-widget-heading\" data-id=\"b77da80\" 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\">Ma\u00eetrisez le langage SQL avec DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fcef210 elementor-widget elementor-widget-text-editor\" data-id=\"fcef210\" 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>Au-del\u00e0 de la requ\u00eate LIKE SQL, il existe une multitude de requ\u00eates \u00e0 conna\u00eetre pour manipuler efficacement les <a href=\"https:\/\/datascientest.com\/bases-de-donnees-relationnelles\">bases de donn\u00e9es relationnelles<\/a>. Si vous souhaitez en savoir plus, <strong>n\u2019h\u00e9sitez pas \u00e0 rejoindre nos formations data.<\/strong><\/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-0b5914a elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0b5914a\" 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\/formation-sql\">\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\">Devenir Expert sur 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-b60ffb4 e-flex e-con-boxed e-con\" data-id=\"b60ffb4\" 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-fe9bf34 elementor-widget elementor-widget-html\" data-id=\"fe9bf34\" 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\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"D\u00e9finition de LIKE SQL\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\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.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment utiliser LIKE SQL ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\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 ?\"\r\n    }\r\n  }]\r\n}\r\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>Afin de communiquer avec les bases de donn\u00e9es, les d\u00e9veloppeurs et experts data peuvent utiliser le langage SQL. Gr\u00e2ce \u00e0 diff\u00e9rentes requ\u00eates, vous pouvez s\u00e9lectionner certaines informations, mettre \u00e0 jour un tableau, ajouter des donn\u00e9es, en supprimer, etc. Parmi les commandes \u00e0 conna\u00eetre, il y a la requ\u00eate LIKE SQL. Mais \u00e0 quoi sert-elle ? [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":199813,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"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 : Comment utiliser cette fonction de recherche ?<\/title>\n<meta name=\"description\" content=\"Pour rechercher des donn\u00e9es sp\u00e9cifiques au sein d\u2019un tableau, il est possible d\u2019utiliser la commande LIKE SQL. Focus.\" \/>\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\/like-sql-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LIKE SQL : Comment utiliser cette fonction de recherche ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/like-sql-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-01T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:52:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/like-sql-datascientest.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/like-sql-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/like-sql-tout-savoir\",\"name\":\"LIKE SQL : Comment utiliser cette fonction de recherche ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-06-01T07:00:00+00:00\",\"dateModified\":\"2023-11-09T13:52:18+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"Pour rechercher des donn\u00e9es sp\u00e9cifiques au sein d\u2019un tableau, il est possible d\u2019utiliser la commande LIKE SQL. Focus.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/like-sql-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"LIKE SQL : Comment utiliser cette fonction de recherche ?","description":"Pour rechercher des donn\u00e9es sp\u00e9cifiques au sein d\u2019un tableau, il est possible d\u2019utiliser la commande LIKE SQL. Focus.","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\/like-sql-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"LIKE SQL : Comment utiliser cette fonction de recherche ?","og_url":"https:\/\/datascientest.com\/like-sql-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-06-01T07:00:00+00:00","article_modified_time":"2023-11-09T13:52:18+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/like-sql-datascientest.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/like-sql-tout-savoir","url":"https:\/\/datascientest.com\/like-sql-tout-savoir","name":"LIKE SQL : Comment utiliser cette fonction de recherche ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-06-01T07:00:00+00:00","dateModified":"2023-11-09T13:52:18+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"Pour rechercher des donn\u00e9es sp\u00e9cifiques au sein d\u2019un tableau, il est possible d\u2019utiliser la commande LIKE SQL. Focus.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/like-sql-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/199794"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=199794"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/199794\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/199813"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=199794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=199794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=199794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}