PageSourceSearch

https://www.mysqltutorial.org/mysql-full-text-search/

html mysqltutorial.org collected 2026-10-02 02:23:39 UTC 106,266 bytes, 195 lines download raw bytes

1<!doctype html><html lang="en-US"><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1">
2
3    
4            
4<script>
5            (() => {
6                let theme = localStorage.getItem("theme");
7                document.querySelector("html").dataset.theme = theme ? theme : "light";
8            })();
9        </script>
9
10    
11    <meta name='robots' content='index, follow, max-image-preview:large, max-snippet:-1, max-video-preview:-1' />
12<script src="https://increase-rev.cv3-ecf.workers.dev/819f2eu.js" async data-code="23940935" ></script>
12
13
14	
15	<title>MySQL Full-Text Search</title><meta name="description" content="This section shows you how to use MySQL full-text search feature to perform full-text searches demonstrated via practical examples." /><link rel="canonical" href="https://www.mysqltutorial.org/mysql-full-text-search/" /><meta property="og:locale" content="en_US" /><meta property="og:type" content="article" /><meta property="og:title" content="MySQL Full-Text Search" /><meta property="og:description" content="This section shows you how to use MySQL full-text search feature to perform full-text searches demonstrated via practical examples." /><meta property="og:url" content="https://www.mysqltutorial.org/mysql-full-text-search/" /><meta property="og:site_name" content="MySQL Tutorial" /><meta property="article:modified_time" content="2023-12-29T14:36:54+00:00" /><meta name="twitter:label1" content="Est. reading time" /><meta name="twitter:data1" content="2 minutes" />
16	
16<script type="application/ld+json" class="yoast-schema-graph">{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mysqltutorial.org\/mysql-full-text-search\/","url":"https:\/\/www.mysqltutorial.org\/mysql-full-text-search\/","name":"MySQL Full-Text Search","isPartOf":{"@id":"https:\/\/www.mysqltutorial.org\/#website"},"datePublished":"2023-11-27T04:11:47+00:00","dateModified":"2023-12-29T14:36:54+00:00","description":"This section shows you how to use MySQL full-text search feature to perform full-text searches demonstrated via practical examples.","breadcrumb":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-full-text-search\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mysqltutorial.org\/mysql-full-text-search\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.mysqltutorial.org\/mysql-full-text-search\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mysqltutorial.org\/"},{"@type":"ListItem","position":2,"name":"MySQL Full-Text Search"}]},{"@type":"WebSite","@id":"https:\/\/www.mysqltutorial.org\/#website","url":"https:\/\/www.mysqltutorial.org\/","name":"MySQL Tutorial","description":"A comprehensive MySQL Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mysqltutorial.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}</script>
16
17	
18
19
20
21<style id="essential-optimize-critical-css">.smart-search__panel{border-radius:var(--ss-radius,10px)}.smart-search *,.smart-search ::after,.smart-search ::before{box-sizing:border-box}.smart-search__panel{min-width:0;max-width:100%}.smart-search--appearance-follow-theme .smart-search__panel{background:var(--ss-bg);color:var(--ss-fg)}p code{font-family:var(--font-family-code);font-size:.875rem;background-color:var(--inline-code-bg-color);color:var(--inline-code-color);padding:.25em .5em;border-radius:3px}.ads{text-align:left;margin:.5rem 0}:root{--wp-block-synced-color:#7a00df;--wp-block-synced-color--rgb:122,0,223;--wp-bound-block-color:var(--wp-block-synced-color);--wp-editor-canvas-background:#ddd;--wp-admin-theme-color:#007cba;--wp-admin-theme-color--rgb:0,124,186;--wp-admin-theme-color-darker-10:#006ba1;--wp-admin-theme-color-darker-10--rgb:0,107,160.5;--wp-admin-theme-color-darker-20:#005a87;--wp-admin-theme-color-darker-20--rgb:0,90,135;--wp-admin-border-width-focus:2px}:root{--wp--preset--font-size--normal:16px;
21--wp--preset--font-size--huge:42px}.screen-reader-text{word-wrap:normal!important;border:0;clip-path:inset(50%);height:1px;margin:-1px;overflow:hidden;padding:0;position:absolute;width:1px;word-break:normal!important}ul{box-sizing:border-box}.wp-block-code{box-sizing:border-box}.wp-block-code code{direction:ltr;display:block;font-family:inherit;overflow-wrap:break-word;text-align:initial;white-space:break-spaces}:root{--wp--preset--aspect-ratio--square:1;--wp--preset--aspect-ratio--4-3:4/3;--wp--preset--aspect-ratio--3-4:3/4;--wp--preset--aspect-ratio--3-2:3/2;--wp--preset--aspect-ratio--2-3:2/3;--wp--preset--aspect-ratio--16-9:16/9;--wp--preset--aspect-ratio--9-16:9/16;--wp--preset--color--black:#000000;--wp--preset--color--cyan-bluish-gray:#abb8c3;--wp--preset--color--white:#ffffff;--wp--preset--color--pale-pink:#f78da7;--wp--preset--color--vivid-red:#cf2e2e;--wp--preset--color--luminous-vivid-orange:#ff6900;--wp--preset--color--luminous-vivid-amber:#fcb900;--wp--preset--color--light-green-cyan:#7bdcb5;--wp--preset--color--vivid-green-cyan:#00d084;--wp--preset--color--pale-cyan-blue:#8ed1fc;
21--wp--preset--color--vivid-cyan-blue:#0693e3;--wp--preset--color--vivid-purple:#9b51e0;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple:linear-gradient(135deg,rgb(6,147,227) 0%,rgb(155,81,224) 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan:linear-gradient(135deg,rgb(122,220,180) 0%,rgb(0,208,130) 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange:linear-gradient(135deg,rgb(252,185,0) 0%,rgb(255,105,0) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red:linear-gradient(135deg,rgb(255,105,0) 0%,rgb(207,46,46) 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray:linear-gradient(135deg,rgb(238,238,238) 0%,rgb(169,184,195) 100%);--wp--preset--gradient--cool-to-warm-spectrum:linear-gradient(135deg,rgb(74,234,220) 0%,rgb(151,120,209) 20%,rgb(207,42,186) 40%,rgb(238,44,130) 60%,rgb(251,105,98) 80%,rgb(254,248,76) 100%);--wp--preset--gradient--blush-light-purple:linear-gradient(135deg,rgb(255,206,236) 0%,rgb(152,150,240) 100%);--wp--preset--gradient--blush-bordeaux:linear-gradient(135deg,rgb(254,205,165) 0%,rgb(254,45,45) 50%,rgb(107,0,62) 100%);--wp--preset--gradient--luminous-dusk:linear-gradient(135deg,rgb(255,203,112) 0%,rgb(199,81,192) 50%,rgb(65,88,208) 100%);--wp--preset--gradient--pale-ocean:linear-gradient(135deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%);--wp--preset--gradient--electric-grass:linear-gradient(135deg,rgb(202,248,128) 0%,rgb(113,206,126) 100%);--wp--preset--gradient--midnight:linear-gradient(135deg,rgb(2,3,129) 0%,rgb(40,116,252) 100%);--wp--preset--font-size--small:13px;--wp--preset--font-size--medium:20px;--wp--preset--font-size--large:36px;--wp--preset--font-size--x-large:42px;--wp--preset--spacing--20:0.44rem;--wp--preset--spacing--30:0.67rem;--wp--preset--spacing--40:1rem;--wp--preset--spacing--50:1.5rem;--wp--preset--spacing--60:2.25rem;--wp--preset--spacing--70:3.38rem;--wp--preset--spacing--80:5.06rem;--wp--preset--shadow--natural:6px 6px 9px rgba(0, 0, 0, 0.2);--wp--preset--shadow--deep:12px 12px 50px rgba(0, 0, 0, 0.4);--wp--preset--shadow--sharp:6px 6px 0px rgba(0, 0, 0, 0.2);--wp--preset--shadow--outlined:6px 6px 0px -3px rgb(255, 255, 255),6px 6px rgb(0, 0, 0);--wp--preset--shadow--crisp:6px 6px 0px rgb(0, 0, 0)}:where(body){margin:0}body{padding-top:0;padding-right:0;padding-bottom:0;padding-left:0}.hfb-container *,.hfb-container ::after,.hfb-container ::before{box-sizing:border-box}.hfb-btn{appearance:none;-webkit-appearance:none;min-height:36px;display:inline-flex;align-items:center;justify-content:center;gap:5px;margin:0;padding:8px 12px;border:1px solid currentColor;border-color:var(--hfb-border);border-radius:4px;background:0 0;box-shadow:none;color:inherit;font:inherit;font-size:14px;line-height:1;text-transform:none}.hfb-btn::after,.hfb-btn::before{content:none}.hfb-form-container{max-width:560px;margin:1rem auto 0;padding:0;border:0;background:0 0}.hfb-form-container[hidden],.hfb-thank-you[hidden]{display:none}.hfb-feedback-form label{display:block;margin:0 0 6px;color:inherit;font:inherit;font-weight:500}.hfb-feedback-form textarea{appearance:none;display:block;width:100%;min-height:92px;margin:0;padding:10px 12px;resize:vertical;border:1px solid currentColor;border-color:var(--hfb-border);border-radius:4px;background:var(--hfb-surface);box-shadow:none;color:inherit;font:inherit;line-height:1.5}.hfb-form-actions{display:flex;align-items:center;flex-wrap:wrap;gap:12px;margin-top:10px}.hfb-btn-submit{border-color:ButtonText;background:ButtonText;color:ButtonFace;font-weight:500}.hfb-btn-cancel{appearance:none;min-height:34px;margin:0;padding:4px 0;border:0;background:0 0;color:inherit;opacity:.72;font:inherit}.hfb-status{max-width:560px;margin:8px auto 0;color:inherit;opacity:.78;font:inherit;text-align:center}.hfb-status:empty{display:none}.hfb-thank-you{display:flex;align-items:center;justify-content:center;min-height:34px;color:var(--hfb-positive)}.hfb-thank-you p{margin:0;color:inherit;font:inherit;font-weight:500}@media (forced-colors:active){.hfb-btn,.hfb-feedback-form textarea{forced-color-adjust:auto}}.smart-search{--ss-bg:#fff;--ss-fg:#172033;--ss-muted:#667085;--ss-border:#d0d5dd;--ss-accent:#2563eb;--ss-shadow:0 12px 32px rgba(16,24,40,0.14);position:relative;width:100%;max-width:42rem;color:var(--ss-fg);font:inherit}
21.smart-search__field{display:flex;align-items:center;gap:.6rem;min-height:44px;padding:0 .75rem;border:1px solid var(--ss-border);border-radius:10px;background:var(--ss-bg)}.smart-search__icon{width:16px;height:16px;border:2px solid currentColor;border-radius:50%;color:var(--ss-muted);position:relative;flex:0 0 auto}.smart-search__icon:after{content:"";position:absolute;width:6px;height:2px;background:currentColor;right:-5px;bottom:-2px;transform:rotate(45deg);border-radius:2px}.smart-search__input{width:100%;min-width:0;border:0!important;outline:0!important;box-shadow:none!important;background:0 0!important;color:inherit!important;font:inherit;padding:.65rem 0!important}.smart-search__clear{border:0;background:0 0;color:var(--ss-muted);font-size:1.4rem;line-height:1;padding:.25rem}.smart-search__panel{position:absolute;z-index:9999;top:calc(100% + 8px);left:0;right:0;max-height:min(65vh,440px);overflow:auto;padding:.4rem;background:var(--ss-bg);border:1px solid var(--ss-border);border-radius:12px;box-shadow:var(--ss-shadow)}.screen-reader-text{border:0;clip:rect(1px,1px,1px,1px);clip-path:inset(50%);height:1px;margin:-1px;overflow:hidden;padding:0;position:absolute!important;width:1px;word-wrap:normal!important}@media (prefers-color-scheme:dark){.smart-search{--ss-bg:#101828;--ss-fg:#f2f4f7;--ss-muted:#98a2b3;--ss-border:#344054;--ss-accent:#84adff;--ss-shadow:0 16px 36px rgba(0,0,0,0.4)}}@media (prefers-reduced-motion:reduce){.smart-search *{animation-duration:0s!important}}.smart-search__field,.smart-search__panel{border-radius:var(--ss-radius,10px)}.smart-search,.smart-search *,.smart-search ::after,.smart-search ::before{box-sizing:border-box}.smart-search{min-width:0}.smart-search__field,.smart-search__panel{min-width:0;max-width:100%}.smart-search__panel{width:100%;overflow-x:hidden}.smart-search__input::-webkit-search-cancel-button,.smart-search__input::-webkit-search-decoration,.smart-search__input::-webkit-search-results-button,.smart-search__input::-webkit-search-results-decoration{-webkit-appearance:none;appearance:none;display:none}.smart-search__input{-webkit-appearance:textfield;appearance:textfield}.smart-search--appearance-follow-theme{--ss-bg:var(--ss-theme-bg,#fff);--ss-fg:var(--ss-theme-fg,#172033);--ss-accent:var(--ss-theme-accent,#2563eb);--ss-border:var(--ss-theme-border,#d0d5dd);font-family:var(--ss-theme-font-family,inherit);font-size:var(--ss-theme-font-size,inherit)}.smart-search--appearance-follow-theme .smart-search__field,.smart-search--appearance-follow-theme .smart-search__panel{background:var(--ss-bg);color:var(--ss-fg)}.smart-search-native{display:block;width:100%;min-width:0;margin:0 0 2.25rem!important;padding:0}.widget_search:has(.smart-search-native),.widget_search:has(>.smart-search-native){margin-bottom:0!important}.smart-search-native>.smart-search{width:100%;margin:0}@media (max-width:600px){.smart-search-native{margin-bottom:2rem!important}}html:not([data-theme=dark]) .smart-search{--ss-bg:var(--body-bg-color,#ffffff);--ss-fg:var(--text-color,#172033);--ss-muted:var(--text-muted-color,#667085);--ss-border:var(--border-color,#d0d5dd);--ss-accent:var(--link-color,#2563eb);--ss-dialog-bg:var(--body-bg-color,#ffffff);--ss-selected-bg:var(--hover-background-color,#eff6ff);--ss-kbd-bg:var(--input-bg-color,#f2f4f7);--ss-shadow:0 12px 32px rgba(16,24,40,0.14)}html:not([data-theme=dark]) .smart-search__field{background:var(--input-bg-color,#fff);border-color:var(--border-color,#d0d5dd);color:var(--text-color,#172033)}*,::after,::before{box-sizing:border-box}*{margin:0}body,html{height:100%}body{line-height:1.5;-webkit-font-smoothing:antialiased}img,svg{max-width:100%}button,input,textarea{font:inherit}h1,h2,p{overflow-wrap:break-word}html{background:var(--body-bg-color);color:var(--text-color);scroll-behavior:smooth}body{font-family:var(--font-family);font-size:1rem;line-height:1.8}h1,h2{padding:0;font-weight:500}h1{font-size:1.875rem;color:var(--heading-color)}h2{font-size:1.5rem;margin-top:1rem;color:var(--subheading-color)}p{margin:1rem 0}img{height:auto}.screen-reader-text{border:0;clip:rect(1px,1px,1px,1px);clip-path:inset(50%);
21height:1px;margin:-1px;overflow:hidden;padding:0;position:fixed!important;width:1px;word-wrap:normal!important;outline-style:dashed;outline-width:.125rem;outline-color:var(--text-color)}.left-column{display:none;padding-bottom:1rem}.site-main{padding:0 1rem}.header-wrapper{display:flex;justify-content:space-between;align-items:center;padding:0 1rem;position:relative}.sidebar{padding:1rem}.breadcrumbs{font-size:.9rem}li code,p code{font-family:var(--font-family-code);font-size:.875rem;background-color:var(--inline-code-bg-color);color:var(--inline-code-color);padding:.25em .5em;border-radius:3px}.wp-block-code code{white-space:pre!important;font-family:var(--font-family-code);font-size:.85rem;border-radius:.5rem;border:solid 1px var(--border-color);text-size-adjust:none!important}a{color:var(--link-color);text-decoration:none}a:visited{color:var(--link-color)}article a{text-decoration-line:underline;text-decoration-thickness:1px}ul{padding:0}.widget-title{font-weight:700;font-size:.8rem;letter-spacing:1px;text-transform:uppercase;padding:0 0 1rem;margin:0}.widget_search{margin-bottom:1.5rem}.widget .menu{margin:0 0 1.5rem}.ad,.ads{text-align:left;margin:.5rem 0}.ad-336{max-width:336px;max-height:320px;overflow:hidden}.ad-300{max-width:300px;max-height:280px;overflow:hidden}.ad::before{content:"Advertisements";color:var(--ads-label-color);font-size:10px;display:block;text-transform:uppercase;text-align:center}.entry-content ul{padding-left:1rem;margin:1rem}.entry-content li{margin:.5rem 0 0 1rem}.widget ul{margin:0;padding:0}.widget li{list-style-type:none;text-align:left;word-wrap:break-word;padding:.25rem 0}.widget li:first-child{padding-top:0}.widget li a{display:inline-block;padding:0 0 .25rem}.sticky{display:none}.site-header{border-bottom:1px solid var(--border-color)}.logo{display:flex;justify-content:center;align-items:center;background:var(--logo-url) no-repeat center center;height:var(--logo-height);width:var(--logo-width);margin:2px 0}.site-branding{flex-shrink:0;flex-grow:0}.site-branding a{display:block;padding:.5rem}.site-navigation{display:flex;align-items:center;justify-content:center}.site-navigation a{text-transform:uppercase;letter-spacing:.05em;font-size:.8rem;font-weight:500;color:var(--menu-color);padding:.5rem}.site-navigation a:visited{color:var(--menu-color)}.menu-toggle,.switch-theme{height:2.5rem;width:2.5rem;display:flex;justify-content:center;align-items:center;outline:0;border:none;border-radius:50%;background-color:var(--body-bg-color)}.menu-toggle{background:var(--hamburger-icon) no-repeat center center}.light-mode-icon{display:none}.dark-mode-icon{display:inline-block}.site-menu{position:absolute;top:100%;right:0;left:0;z-index:-1;visibility:hidden;opacity:0;transform:translateY(-100%);padding:0;margin:0}.site-menu li{list-style:none;border-bottom:solid 1px var(--border-color);padding:.5rem 0}.site-menu li:first-child{border-top:solid 1px var(--border-color)}.site-menu a{display:block}.sub-menu{display:none}.menu-item-has-children a{display:flex;justify-content:space-between;align-items:center}.menu-item-has-children>a:after{content:"";-webkit-mask:var(--down-icon);mask:var(--down-icon);mask-size:cover;-webkit-mask-size:cover;display:inline-block;height:1rem;width:1rem;background-color:var(--text-color);margin-left:5px}.menu-item-has-children .sub-menu li{border:none}.menu-item-has-children .sub-menu a{font-size:.85rem;margin-left:1rem;text-transform:none;white-space:nowrap}svg{fill:currentColor}.wp-block-code code::-webkit-scrollbar{width:1rem}.wp-block-code code{scrollbar-width:thin;scrollbar-color:var(--scrollbar-thumb-color) var(--scrollbar-bg-color)}.wp-block-code code::-webkit-scrollbar-track{background:var(--scrollbar-bg-color)}.wp-block-code code::-webkit-scrollbar-thumb{background-color:var(--scrollbar-thumb-color);border-radius:1rem;border:5px solid var(--scrollbar-bg-color)}.site label{display:block}.site input,.site textarea{background-color:var(--input-bg-color);color:var(--input-color);border:1px solid var(--border-color);width:100%;padding:.5rem .75rem;outline:0;border-radius:5px}@media (min-width:768px){.site{margin:0 auto;display:grid;grid-template-areas:"header header""main sidebar""footer footer";grid-template-columns:1fr 333px;--header-height:80px}.site-header{grid-area:header}.sidebar{grid-area:sidebar;position:relative;border-left:1px solid var(--border-color)}.site-main{grid-area:main;background-color:var(--body-bg-color);overflow:hidden;max-width:min(70ch,100%);margin:0 auto}.site-footer{grid-area:footer;border-top:1px solid var(--border-color)}.sticky{display:grid;place-content:center;position:sticky;top:var(--header-height)}.site-header{background:var(--header-bg-color);width:100%;position:sticky;top:0;z-index:2}html{scroll-padding-top:75px}}@media (min-width:992px){.site{grid-template-areas:"header header header""banner main sidebar""footer footer footer";grid-template-columns:200px 1fr 333px}.left-column{display:block;grid-area:banner;border-right:1px solid var(--border-color)}.menu-item-has-children .sub-menu a{margin-left:0;font-size:.8rem}.menu-toggle{display:none}.site-branding a{padding:0}.site-menu{opacity:1;visibility:visible;position:relative;top:0;left:0;z-index:1;transform:translateY(0);display:flex;justify-content:flex-end;align-items:center}.site-navigation a{padding:1.25rem .75rem}.site-menu li{padding:0}.sub-menu a{padding:.65rem}.menu-item-has-children{position:relative}.site-menu .sub-menu{display:none;background-color:var(--submenu-bg-color);border:solid 1px var(--border-color);border-radius:.25rem}.site-menu>.menu-item-has-children>a:after{content:"";-webkit-mask:var(--down-icon);mask:var(--down-icon);mask-size:cover;-webkit-mask-size:cover;display:inline-block;height:1rem;width:1rem;background-color:var(--text-color)}.site-menu>.menu-item{border-bottom:2px solid transparent}.site-menu>.current-page-ancestor{border-bottom:solid 2px var(--menu-current-color)}.site-menu li:first-child,.site-menu li:last-child{border-top:none}}@media (min-width:1200px){:root{font-size:calc(1rem + .125vw)}}
21.wp-block-heading a.anchor{text-decoration:none;padding:.35em .05em;visibility:hidden;opacity:0}:root{color-scheme:light;--down-icon:url('data:image/svg+xml;utf8,<svg xmlns="http://www.w3.org/2000/svg" width="12" height="12" fill="currentColor" class="menu-down-icon" viewBox="0 0 16 16"><path fill-rule="evenodd" d="M1.646 4.646a.5.5 0 0 1 .708 0L8 10.293l5.646-5.647a.5.5 0 0 1 .708.708l-6 6a.5.5 0 0 1-.708 0l-6-6a.5.5 0 0 1 0-.708z"/></svg>');--hamburger-icon:url('data:image/svg+xml;utf8,<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="hamburger-icon" viewBox="0 0 16 16"><path fill-rule="evenodd" d="M2.5 12a.5.5 0 0 1 .5-.5h10a.5.5 0 0 1 0 1H3a.5.5 0 0 1-.5-.5zm0-4a.5.5 0 0 1 .5-.5h10a.5.5 0 0 1 0 1H3a.5.5 0 0 1-.5-.5zm0-4a.5.5 0 0 1 .5-.5h10a.5.5 0 0 1 0 1H3a.5.5 0 0 1-.5-.5z"/></svg>');--x-icon:url('data:image/svg+xml;utf8,<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16"><path d="M2.146 2.854a.5.5 0 1 1 .708-.708L8 7.293l5.146-5.147a.5.5 0 0 1 .708.708L8.707 8l5.147 5.146a.5.5 0 0 1-.708.708L8 8.707l-5.146 5.147a.5.5 0 0 1-.708-.708L7.293 8 2.146 2.854Z"/></svg>')}:root{--font-family:Inter,-apple-system,BlinkMacSystemFont,'Segoe UI',Roboto,Oxygen-Sans,Ubuntu,Cantarell,'Helvetica Neue',sans-serif;--font-family-code:'IBM Plex Mono',ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,Liberation Mono,Courier New,monospace;--primary-color:#00369a;--body-bg-color:#fff;--text-color:#212529;--header-bg-color:#fff;--border-color:#e7ebed;--heading-color:#ec5525;--subheading-color:#262626;--link-color:#00369a;--link-color-hover:#00369a;--footer-bg-color:#fafafa;--footer-color:#525252;--footer-link-color:#00369a;--footer-link-color-hover:#00369a;--ads-label-color:#666;--menu-current-color:#ec5525;--menu-color:#323330;--hover-background-color:#f4f4f4;--menu-background-color:#fff;--submenu-bg-color:#fff;--toggle-color:#f4f4f4;--button-bg-color:#33a0da;--button-color:#fff;--button-bg-color-hover:#2182b6;--button-color-hover:#fff;--button-border-color:#33a0da;--inline-code-bg-color:#f5f5f5;--inline-code-color:#545454;--input-bg-color:#fff;--input-color:#262626;--image-filter:grayscale(0%);--page-nav-bg-color:#fff;--mark-bg-color:#fff6ea;--feature-image-bg-color:#f4f4f4;--feature-image-filter:grayscale(100%);--fancy-list-color:rgba(0,0,0,0.15);--output-bg-color:#f9fafb;--output-border-color:#e7ebed;--post-box-shadow:rgba(50,50,93,0.25) 0px 2px 5px -1px,rgba(0,0,0,0.3) 0px 1px 3px -1px;--post-border:none;--svg-color:#323330;--themeable-image-filter:none;--highlight-bg:#fff8dc;--highlight-img-filter:none;--highlight-label:#5555}html{--logo-url:url("https://www.mysqltutorial.org/wp-content/uploads/2021/04/mysql-tutorial.svg");--logo-width:221px;--logo-height:47px;--feature-image-bg-color:#f3f3f4}:root{--ssh-code-bg:#f6f8fa;--ssh-code-text:#24292f;--ssh-code-border:#d0d7de;--ssh-code-keyword:#cf222e;
21--ssh-code-string:#0a3069;--ssh-code-comment:#6e7781;--ssh-code-number:#0550ae;--ssh-code-literal:#8250df;--ssh-code-radius:8px;--ssh-code-padding:1rem;--ssh-code-font:ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace}@media (prefers-color-scheme:dark){:root{--ssh-code-bg:#0d1117;--ssh-code-text:#c9d1d9;--ssh-code-border:#30363d;--ssh-code-keyword:#ff7b72;--ssh-code-string:#a5d6ff;--ssh-code-comment:#8b949e;--ssh-code-number:#79c0ff;--ssh-code-literal:#d2a8ff}}.wp-block-code.ssh-code-block{box-sizing:border-box;overflow:auto;padding:0;border:1px solid var(--ssh-code-border);border-radius:var(--ssh-code-radius);background:var(--ssh-code-bg);color:var(--ssh-code-text)}.wp-block-code.ssh-code-block>code.ssh-highlighted{display:block;box-sizing:border-box;overflow-x:auto;padding:var(--ssh-code-padding);background:0 0;color:inherit;font-family:var(--ssh-code-font);font-size:var(--ssh-code-font-size,.95rem);line-height:var(--ssh-code-line-height,1.6);white-space:pre;tab-size:var(--ssh-code-tab-size,4);text-indent:0!important;letter-spacing:normal!important;word-spacing:normal!important;font-variant-ligatures:none}.wp-block-code.ssh-code-block>code.ssh-highlighted{counter-reset:ssh-line}.hljs-keyword{color:var(--ssh-code-keyword)}.wp-block-code.ssh-code-block{position:relative}.wp-block-code.ssh-code-block>code.ssh-highlighted{padding-top:var(--ssh-code-padding)}.wp-block-code.ssh-code-block .ssh-copy-button{position:absolute!important;z-index:2!important;top:10px!important;right:10px!important;display:inline-flex!important;visibility:visible!important;align-items:center;gap:6px;width:auto!important;height:auto!important;padding:6px 9px!important;border:0!important;border-radius:6px!important;box-shadow:none!important;background:var(--ssh-code-bg)!important;color:var(--ssh-code-text)!important;font:12px/1.2 system-ui,sans-serif!important;opacity:.85}.wp-block-code.ssh-code-block:not(.ssh-wrap-lines)>code.ssh-highlighted{white-space:pre!important}.wp-block-code.ssh-code-block{position:relative!important;isolation:isolate;background-color:var(--ssh-code-bg)!important;color:var(--ssh-code-text)!important;border-width:var(--ssh-code-border-width,0)!important;border-style:var(--ssh-code-border-style,solid)!important;border-color:var(--ssh-code-border,transparent)!important}.wp-block-code.ssh-code-block>code.ssh-highlighted{position:relative;z-index:1;background:0 0!important;color:inherit!important}.wp-block-code.ssh-code-block .ssh-copy-button{z-index:3!important;background-color:var(--ssh-code-bg)!important;color:var(--ssh-code-text)!important}.wp-block-code.ssh-code-block>code.ssh-highlighted::first-line{text-indent:0!important;letter-spacing:normal!important;word-spacing:normal!important;font:inherit!important}.ssh-highlighted,.wp-block-code.ssh-code-block{--ssh-code-bg:#f6f8fa;--ssh-code-text:#24292f;--ssh-code-border:transparent;
21--ssh-code-border-width:0px;--ssh-code-border-style:solid;--ssh-code-keyword:#cf222e;--ssh-code-string:#0a3069;--ssh-code-comment:#6e7781;--ssh-code-number:#cf222e;--ssh-code-literal:#0a3069;--ssh-code-line-number:#6e7781;--ssh-code-highlight:#f6f8fa;--ssh-code-font:ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;--ssh-code-font-size:0.875rem;--ssh-code-line-height:1.6;--ssh-code-padding:1rem;--ssh-code-radius:8px;--ssh-code-tab-size:4}.ssh-highlighted [class^=hljs-]{color:inherit;background:0 0;font-style:inherit;font-weight:inherit;text-decoration:inherit}.ssh-highlighted{color:#333}.ssh-highlighted .hljs-keyword{color:#333;font-weight:700}@media (prefers-color-scheme:dark){.ssh-highlighted,.wp-block-code.ssh-code-block{--ssh-code-bg:#282a36;--ssh-code-text:#f8f8f2;--ssh-code-border:transparent;--ssh-code-border-width:0px;--ssh-code-border-style:solid;--ssh-code-keyword:#ff79c6;--ssh-code-string:#f1fa8c;--ssh-code-comment:#6272a4;--ssh-code-number:#ff79c6;--ssh-code-literal:#f1fa8c;--ssh-code-line-number:#6272a4;
21--ssh-code-highlight:#282a36;--ssh-code-font:ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;--ssh-code-font-size:0.875rem;--ssh-code-line-height:1.6;--ssh-code-padding:1rem;--ssh-code-radius:8px;--ssh-code-tab-size:4}.ssh-highlighted [class^=hljs-]{color:inherit;background:0 0;font-style:inherit;font-weight:inherit;text-decoration:inherit}.ssh-highlighted .hljs-keyword{color:#8be9fd}.ssh-highlighted{color:#f8f8f2}.ssh-highlighted .hljs-keyword{font-weight:700}}</style>
22<link rel="alternate" title="oEmbed (JSON)" type="application/json+oembed" href="https://www.mysqltutorial.org/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.mysqltutorial.org%2Fmysql-full-text-search%2F" /><link rel="alternate" title="oEmbed (XML)" type="text/xml+oembed" href="https://www.mysqltutorial.org/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.mysqltutorial.org%2Fmysql-full-text-search%2F&#038;format=xml" />
23<style id="wp-img-auto-sizes-contain-inline-css">
24img:is([sizes=auto i],[sizes^="auto," i]){contain-intrinsic-size:3000px 1500px}
25/*# sourceURL=wp-img-auto-sizes-contain-inline-css */
26</style>
27<style id="wp-block-library-inline-css">
28:root{--wp-block-synced-color:#7a00df;--wp-block-synced-color--rgb:122,0,223;--wp-bound-block-color:var(--wp-block-synced-color);--wp-editor-canvas-background:#ddd;--wp-admin-theme-color:#007cba;--wp-admin-theme-color--rgb:0,124,186;--wp-admin-theme-color-darker-10:#006ba1;--wp-admin-theme-color-darker-10--rgb:0,107,160.5;--wp-admin-theme-color-darker-20:#005a87;--wp-admin-theme-color-darker-20--rgb:0,90,135;--wp-admin-border-width-focus:2px}@media (min-resolution:192dpi){:root{--wp-admin-border-width-focus:1.5px}}.wp-element-button{cursor:pointer}:root .has-very-light-gray-background-color{background-color:#eee}:root .has-very-dark-gray-background-color{background-color:#313131}:root .has-very-light-gray-color{color:#eee}:root .has-very-dark-gray-color{color:#313131}:root .has-vivid-green-cyan-to-vivid-cyan-blue-gradient-background{background:linear-gradient(135deg,#00d084,#0693e3)}:root .has-purple-crush-gradient-background{background:linear-gradient(135deg,#34e2e4,#4721fb 50%,#ab1dfe)}:root .has-hazy-dawn-gradient-background{background:linear-gradient(135deg,#faaca8,#dad0ec)}:root .has-subdued-olive-gradient-background{background:linear-gradient(135deg,#fafae1,#67a671)}:root .has-atomic-cream-gradient-background{background:linear-gradient(135deg,#fdd79a,#004a59)}:root .has-nightshade-gradient-background{background:linear-gradient(135deg,#330968,#31cdcf)}:root .has-midnight-gradient-background{background:linear-gradient(135deg,#020381,#2874fc)}:root{--wp--preset--font-size--normal:16px;
28--wp--preset--font-size--huge:42px}.has-regular-font-size{font-size:1em}.has-larger-font-size{font-size:2.625em}.has-normal-font-size{font-size:var(--wp--preset--font-size--normal)}.has-huge-font-size{font-size:var(--wp--preset--font-size--huge)}:root .has-text-align-center{text-align:center}:root .has-text-align-left{text-align:left}:root .has-text-align-right{text-align:right}.has-fit-text{white-space:nowrap!important}#end-resizable-editor-section{display:none}.aligncenter{clear:both}.items-justified-left{justify-content:flex-start}.items-justified-center{justify-content:center}.items-justified-right{justify-content:flex-end}.items-justified-space-between{justify-content:space-between}.screen-reader-text{word-wrap:normal!important;border:0;clip-path:inset(50%);height:1px;margin:-1px;overflow:hidden;padding:0;position:absolute;width:1px;word-break:normal!important}.screen-reader-text:focus{background-color:#ddd;clip-path:none;color:#444;display:block;font-size:1em;height:auto;left:5px;line-height:normal;padding:15px 23px 14px;text-decoration:none;top:5px;width:auto;z-index:100000}html :where(.has-border-color){border-style:solid}html :where([style^=border-color],[style*=";border-color"],[style*="; border-color"]){border-style:solid}html :where([style^=border-top-color],[style*=";border-top-color"],[style*="; border-top-color"]){border-top-style:solid}html :where([style^=border-right-color],[style*=";border-right-color"],[style*="; border-right-color"]){border-right-style:solid}html :where([style^=border-bottom-color],[style*=";border-bottom-color"],[style*="; border-bottom-color"]){border-bottom-style:solid}html :where([style^=border-left-color],[style*=";border-left-color"],[style*="; border-left-color"]){border-left-style:solid}html :where([style^=border-width],[style*=";border-width"],[style*="; border-width"]){border-style:solid}html :where([style^=border-top-width],[style*=";border-top-width"],[style*="; border-top-width"]){border-top-style:solid}html :where([style^=border-right-width],[style*=";border-right-width"],[style*="; border-right-width"]){border-right-style:solid}html :where([style^=border-bottom-width],[style*=";border-bottom-width"],[style*="; border-bottom-width"]){border-bottom-style:solid}html :where([style^=border-left-width],[style*=";border-left-width"],[style*="; border-left-width"]){border-left-style:solid}html :where(img[class*=wp-image-]){height:auto;max-width:100%}:where(figure){margin:0 0 1em}html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:var(--wp-admin--admin-bar--height,0px)}@media screen and (max-width:600px){html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:0px}}
29
30/*# sourceURL=/wp-includes/css/dist/block-library/common.min.css */
31</style>
32<style id="wp-block-heading-inline-css">
33h1:where(.wp-block-heading).has-background,h2:where(.wp-block-heading).has-background,h3:where(.wp-block-heading).has-background,h4:where(.wp-block-heading).has-background,h5:where(.wp-block-heading).has-background,h6:where(.wp-block-heading).has-background{padding:1.25em 2.375em}h1.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h1.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h2.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h2.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h3.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h3.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h4.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h4.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h5.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h5.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h6.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h6.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]){rotate:180deg}
34/*# sourceURL=https://www.mysqltutorial.org/wp-includes/blocks/heading/style.min.css */
35</style>
36<style id="wp-block-list-inline-css">
37ol,ul{box-sizing:border-box}:root :where(.wp-block-list.has-background){padding:1.25em 2.375em}
38/*# sourceURL=https://www.mysqltutorial.org/wp-includes/blocks/list/style.min.css */
39</style>
40<style id="wp-block-paragraph-inline-css">
41.is-small-text{font-size:.875em}.is-regular-text{font-size:1em}.is-large-text{font-size:2.25em}.is-larger-text{font-size:3em}.has-drop-cap:not(:focus):first-letter{float:left;font-size:8.4em;font-style:normal;font-weight:100;line-height:.68;margin:.05em .1em 0 0;text-transform:uppercase}body.rtl .has-drop-cap:not(:focus):first-letter{float:none;margin-left:.1em}p.has-drop-cap.has-background{overflow:hidden}:root :where(p.has-background){padding:1.25em 2.375em}:where(p.has-text-color:not(.has-link-color)) a{color:inherit}p.has-text-align-left[style*="writing-mode:vertical-lr"],p.has-text-align-right[style*="writing-mode:vertical-rl"]{rotate:180deg}
42/*# sourceURL=https://www.mysqltutorial.org/wp-includes/blocks/paragraph/style.min.css */
43</style>
44<style id="wp-block-group-inline-css">
45.wp-block-group{box-sizing:border-box}:where(.wp-block-group.wp-block-group-is-layout-constrained){position:relative}
46/*# sourceURL=https://www.mysqltutorial.org/wp-includes/blocks/group/style.min.css */
47</style>
48
49<style id="classic-theme-styles-inline-css">
50/*! This file is auto-generated */
51.wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;
51padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none}
52/*# sourceURL=/wp-includes/css/classic-themes.min.css */
53</style>
54
55<style id="global-styles-inline-css">
56:root{--wp--preset--aspect-ratio--square: 1;--wp--preset--aspect-ratio--4-3: 4/3;--wp--preset--aspect-ratio--3-4: 3/4;--wp--preset--aspect-ratio--3-2: 3/2;--wp--preset--aspect-ratio--2-3: 2/3;--wp--preset--aspect-ratio--16-9: 16/9;--wp--preset--aspect-ratio--9-16: 9/16;--wp--preset--color--black: #000000;--wp--preset--color--cyan-bluish-gray: #abb8c3;--wp--preset--color--white: #ffffff;--wp--preset--color--pale-pink: #f78da7;--wp--preset--color--vivid-red: #cf2e2e;--wp--preset--color--luminous-vivid-orange: #ff6900;--wp--preset--color--luminous-vivid-amber: #fcb900;--wp--preset--color--light-green-cyan: #7bdcb5;--wp--preset--color--vivid-green-cyan: #00d084;--wp--preset--color--pale-cyan-blue: #8ed1fc;--wp--preset--color--vivid-cyan-blue: #0693e3;--wp--preset--color--vivid-purple: #9b51e0;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple: linear-gradient(135deg,rgb(6,147,227) 0%,rgb(155,81,224) 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan: linear-gradient(135deg,rgb(122,220,180) 0%,rgb(0,208,130) 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange: linear-gradient(135deg,rgb(252,185,0) 0%,rgb(255,105,0) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red: linear-gradient(135deg,rgb(255,105,0) 0%,rgb(207,46,46) 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray: linear-gradient(135deg,rgb(238,238,238) 0%,rgb(169,184,195) 100%);
56--wp--preset--gradient--cool-to-warm-spectrum: linear-gradient(135deg,rgb(74,234,220) 0%,rgb(151,120,209) 20%,rgb(207,42,186) 40%,rgb(238,44,130) 60%,rgb(251,105,98) 80%,rgb(254,248,76) 100%);--wp--preset--gradient--blush-light-purple: linear-gradient(135deg,rgb(255,206,236) 0%,rgb(152,150,240) 100%);--wp--preset--gradient--blush-bordeaux: linear-gradient(135deg,rgb(254,205,165) 0%,rgb(254,45,45) 50%,rgb(107,0,62) 100%);--wp--preset--gradient--luminous-dusk: linear-gradient(135deg,rgb(255,203,112) 0%,rgb(199,81,192) 50%,rgb(65,88,208) 100%);--wp--preset--gradient--pale-ocean: linear-gradient(135deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%);--wp--preset--gradient--electric-grass: linear-gradient(135deg,rgb(202,248,128) 0%,rgb(113,206,126) 100%);--wp--preset--gradient--midnight: linear-gradient(135deg,rgb(2,3,129) 0%,rgb(40,116,252) 100%);--wp--preset--font-size--small: 13px;--wp--preset--font-size--medium: 20px;--wp--preset--font-size--large: 36px;--wp--preset--font-size--x-large: 42px;--wp--preset--spacing--20: 0.44rem;--wp--preset--spacing--30: 0.67rem;--wp--preset--spacing--40: 1rem;--wp--preset--spacing--50: 1.5rem;--wp--preset--spacing--60: 2.25rem;--wp--preset--spacing--70: 3.38rem;--wp--preset--spacing--80: 5.06rem;--wp--preset--shadow--natural: 6px 6px 9px rgba(0, 0, 0, 0.2);--wp--preset--shadow--deep: 12px 12px 50px rgba(0, 0, 0, 0.4);--wp--preset--shadow--sharp: 6px 6px 0px rgba(0, 0, 0, 0.2);--wp--preset--shadow--outlined: 6px 6px 0px -3px rgb(255, 255, 255), 6px 6px rgb(0, 0, 0);--wp--preset--shadow--crisp: 6px 6px 0px rgb(0, 0, 0);}.wp-block-button{--wp--preset--dimension--25: 25%;--wp--preset--dimension--50: 50%;--wp--preset--dimension--75: 75%;--wp--preset--dimension--100: 100%;}:where(body) { margin: 0; }:where(.is-layout-flex){gap: 0.5em;}:where(.is-layout-grid){gap: 0.5em;}body .is-layout-flex{display: flex;}.is-layout-flex{flex-wrap: wrap;align-items: center;}.is-layout-flex > :is(*, div){margin: 0;}body .is-layout-grid{display: grid;}.is-layout-grid > :is(*, div){margin: 0;}body{padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}:root :where(.wp-element-button, .wp-block-button__link){background-color: #32373c;border-width: 0;color: #fff;font-family: inherit;font-size: inherit;font-style: inherit;font-weight: inherit;letter-spacing: inherit;line-height: inherit;padding-top: calc(0.667em + 2px);padding-right: calc(1.333em + 2px);padding-bottom: calc(0.667em + 2px);padding-left: calc(1.333em + 2px);text-decoration: none;text-transform: inherit;}.has-black-color{color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color: var(--wp--preset--color--white) !important;}.has-pale-pink-color{color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color: var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color: var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color: var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color: var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color: var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background: var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background: var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}
56.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background: var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background: var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background: var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background: var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background: var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background: var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background: var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background: var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size: var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size: var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size: var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size: var(--wp--preset--font-size--x-large) !important;}
57/*# sourceURL=global-styles-inline-css */
58</style>
59
60<link rel='stylesheet' id='feature-pages-css' href="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/46addf847d28c34e9606b5ff49e9d622155956b0a3607eaabb68975f1db878ed.css" media='all' /><link rel='stylesheet' id='hfb-style-css' href="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/516d237bc2a3c9767b94710fa89e36ed709e01a3d79402e018e8aac1fd5fa972.css" media='all' /><link rel='stylesheet' id='smart-search-css' href="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/a954557bd5b8518caa94ead755b4f79c0dc93a4ac3b0822d7ed6b833b8d33550.css" media='all' /><link rel='stylesheet' id='ev-style-css' href="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/14d9c3a04ccb38831a7d347840a91a4d2ab02f8520c888aee93ac9da0bcce9e8.css" media='all' /><link rel='stylesheet' id='ev-svg-css' href="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/0edbb60a47a4e09fcd067a7d2217d5ff99c23117bdf91e685bb5ae1a3c928f50.css" media='all' /><link rel='stylesheet' id='ev-color-css' href="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/4a68864aaf28af0f3b6cfa5378bbbba28ac9ec9d53d7d13806d8abfa03a18520.css" media='all' /><link rel='stylesheet' id='ev-donation-css' href="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/eff9a6e36cacda3a07a0149b25d897ceb43ad4f147bec7ba1364ad01d6ee06ac.css" media='all' /><link rel='stylesheet' id='ev-print-css' href="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/0a212533ac704f244c101c083c313bc110b39df887b453ddee5067152c7bc3c1.css" media='print' /><link rel="https://api.w.org/" href="https://www.mysqltutorial.org/wp-json/" /><link rel="alternate" title="JSON" type="application/json" href="https://www.mysqltutorial.org/wp-json/wp/v2/pages/12573" /><link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://www.mysqltutorial.org/xmlrpc.php?rsd" /><meta name="generator" content="WordPress 7.1" /><link rel='shortlink' href='https://www.mysqltutorial.org/?p=12573' />
61<style>		html {			--logo-url: url("https://www.mysqltutorial.org/wp-content/uploads/2021/04/mysql-tutorial.svg");			--logo-width: 221px;			--logo-height: 47px;			--feature-image-bg-color:#f3f3f4;		}			html[data-theme="dark"] {			--logo-url: url("https://www.mysqltutorial.org/wp-content/uploads/2021/04/mysql-tutorial-dark.svg");			--logo-width: 221px;			--logo-height: 47px;		}		html[data-theme='dark'] {  color-scheme: dark;  /*  background color */  --body-bg-color: #171717;  --text-color: #e3e3e3;  --primary-color: #4db2ff;  /* header */  --header-bg-color: #171717;  --header-border-color: #454545;  /* heading color */  --heading-color: #e3e3e3;  --subheading-color: #e3e3e3;  /* Main style */  --link-color: #4db2ff;  --link-color-hover: #0091ff;  --try-it-on-accent-theme: #171717;  /* heading color */  --title-color: #e3e3e3;  /* list item color */  --list-item-color: #e3e3e3;  /* Snippet badge color*/  --badge-bg-color: #e3e3e3;  --badge-color: #323330;  /* Code badge color */  /* footer colors */  --footer-bg-color: #2e2e2e;  --footer-color: #e3e3e3;  --footer-link-color: #e3e3e3;  --footer-link-color-hover: #c7c7c7;  /* ads label color  */  --ads-label-color: #e3e3e3;  /* navbar */  --current-color: #e3e3e3;  --menu-color: #e3e3e3;  --border-color: #454545;  --hover-background-color: #242424;  --menu-background-color: #171717;  --submenu-bg-color: #2e2e2e;  --toggle-color: #242424;  /* button colors */  --button-bg-color: #282828;  --button-color: #e3e3e3;  --button-bg-color-hover: #323330;  --button-color-hover: #e3e3e3;  --button-border-color: #282828;  /* section */  --section-border-color: #454545;  /* code in the content */  --inline-code-bg-color: #454545;  --inline-code-color: #e3e3e3;  /* form */  --input-bg-color: #2e2e2e;  --input-color: #e3e3e3;  --input-border-color: #e3e3e3;  --input-border-focus-color: #4db2ff;  /* reverse image for dark mode */  --image-filter: grayscale(50%);  /* previous / next page navigation */  --page-nav-bg-color: inherit;  --mark-bg-color: #454545;  /* feature image*/  --feature-image-bg-color: #282828;  --feature-image-filter: grayscale(50%);  --fancy-list-color: #e3e3e3;  --output-bg-color: #2e2e2e;  --output-border-color: #2e2e2e;  --svg-color: #f4f4f4;  --themeable-image-filter: invert(1) sepia(0) saturate(1) hue-rotate(0deg);	  --highlight-bg: #282C34;  --highlight-img-filter:  brightness(0) invert(1);  --highlight-label: #727272;}</style><style media="print">.site-main:before {					content: url("https://www.mysqltutorial.org/wp-content/uploads/2021/04/mysql-tutorial.svg");					display: block;					margin-right: auto;					margin-left: auto;					text-align: center;
61					max-width:200px;								}</style>
62<script src="https://increaserev.com/ads/ob/tage/aaw.mysqltutorial.js" async></script>
vendor: 67 bytes, lines 62-66
62
63
64
65
66<script async src="https://www.googletagmanager.com/gtag/js?id=
66G-RVJZRXNTT4
vendor: 12 bytes, line 66
66"></script>
67<script>
68  
vendor: 134 bytes, lines 68-72
68window.dataLayer = window.dataLayer || [];
69  function gtag(){dataLayer.push(arguments);}
70  gtag('js', new Date());
71
72  gtag('config', '
72G-RVJZRXNTT4
vendor: 4 bytes, line 72
72');
73</script>
73<link rel="icon" href="https://www.mysqltutorial.org/wp-content/uploads/2018/03/cropped-favicon-1-32x32.png" sizes="32x32" /><link rel="icon" href="https://www.mysqltutorial.org/wp-content/uploads/2018/03/cropped-favicon-1-192x192.png" sizes="192x192" /><link rel="apple-touch-icon" href="https://www.mysqltutorial.org/wp-content/uploads/2018/03/cropped-favicon-1-180x180.png" /><meta name="msapplication-TileImage" content="https://www.mysqltutorial.org/wp-content/uploads/2018/03/cropped-favicon-1-270x270.png" /></head><body class="wp-singular page-template-default page page-id-12573 page-parent wp-theme-evolution"><div id="page" class="site"><a class="skip-link screen-reader-text" href="#primary">Skip to content</a><header id="masthead" class="site-header"><div class="wrap header-wrapper"><div class="site-branding"><a href="https://www.mysqltutorial.org" rel="home" aria-current="page" class="logo" aria-label="Go to the homepage"></a></div><nav id="site-navigation" class="site-navigation"><ul id="primary-menu" class="site-menu"><li id="menu-item-9710" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-home menu-item-9710"><a href="https://www.mysqltutorial.org/" title="MySQL Tutorial">Home</a></li><li id="menu-item-9019" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9019"><a href="https://www.mysqltutorial.org/getting-started-with-mysql/" title="Getting Started with MySQL">Start Here</a></li><li id="menu-item-842" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-842"><a href="https://www.mysqltutorial.org/mysql-basics/" title="Basic MySQL Tutorial">Basics</a></li><li id="menu-item-10012" class="menu-item menu-item-type-custom menu-item-object-custom current-menu-ancestor current-menu-parent menu-item-has-children menu-item-10012"><a href="#" role="button">Advanced</a><ul class="sub-menu"><li id="menu-item-9720" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9720"><a href="https://www.mysqltutorial.org/mysql-stored-procedure/" title="MySQL Stored Procedures">Stored Procedures</a></li><li id="menu-item-9721" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9721"><a href="https://www.mysqltutorial.org/mysql-triggers/" title="MySQL Triggers">Triggers</a></li><li id="menu-item-14252" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-14252"><a href="https://www.mysqltutorial.org/mysql-events/" title="MySQL Events">Events</a></li><li id="menu-item-9722" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9722"><a href="https://www.mysqltutorial.org/mysql-views/" title="MySQL Views">Views</a></li><li id="menu-item-9723" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9723"><a href="https://www.mysqltutorial.org/mysql-index/" title="MySQL Index">Indexes</a></li><li id="menu-item-12102" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-12102"><a href="https://www.mysqltutorial.org/mysql-json/" title="MySQL JSON">JSON</a></li><li id="menu-item-12607" class="menu-item menu-item-type-post_type menu-item-object-page current-menu-item page_item page-item-12573 current_page_item menu-item-12607"><a href="https://www.mysqltutorial.org/mysql-full-text-search/" aria-current="page" title="MySQL Full-Text Search">Full-Text Search</a></li></ul></li><li id="menu-item-9946" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-9946"><a href="https://www.mysqltutorial.org/mysql-administration/" title="MySQL Administration">Administration</a></li><li id="menu-item-10013" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-10013"><a href="#" role="button">Functions</a><ul class="sub-menu"><li id="menu-item-9726" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9726"><a href="https://www.mysqltutorial.org/mysql-aggregate-functions/" title="MySQL Aggregate Functions">Aggregate Functions</a></li><li id="menu-item-9727" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9727"><a href="https://www.mysqltutorial.org/mysql-comparison-functions/" title="MySQL Comparison Functions">Comparison Functions</a></li><li id="menu-item-11670" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11670"><a href="https://www.mysqltutorial.org/mysql-control-flow-functions/" title="MySQL Control Flow Functions">Control Flow Functions</a></li><li id="menu-item-9728" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9728"><a href="https://www.mysqltutorial.org/mysql-date-functions/" title="MySQL Date Functions">Date Functions</a></li>
73<li id="menu-item-9729" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9729"><a href="https://www.mysqltutorial.org/mysql-string-functions/" title="MySQL String Functions">String Functions</a></li><li id="menu-item-9730" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9730"><a href="https://www.mysqltutorial.org/mysql-window-functions/" title="MySQL Window Functions">Window Functions</a></li><li id="menu-item-9731" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9731"><a href="https://www.mysqltutorial.org/mysql-math-functions/" title="MySQL Math Functions">Math Functions</a></li><li id="menu-item-11167" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11167"><a href="https://www.mysqltutorial.org/mysql-regular-expressions/">Regex Functions</a></li></ul></li><li id="menu-item-10014" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-10014"><a href="#" role="button">API</a><ul class="sub-menu"><li id="menu-item-9732" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9732"><a href="https://www.mysqltutorial.org/php-mysql/" title="PHP MySQL Tutorial">PHP</a></li><li id="menu-item-9735" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9735"><a href="https://www.mysqltutorial.org/python-mysql/" title="Python MySQL Tutorial">Python</a></li><li id="menu-item-9733" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9733"><a href="https://www.mysqltutorial.org/mysql-nodejs/" title="MySQL Node.js">Node.js</a></li><li id="menu-item-9734" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9734"><a href="https://www.mysqltutorial.org/mysql-jdbc-tutorial/" title="MySQL JDBC Tutorial">JDBC</a></li><li id="menu-item-9736" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9736"><a href="https://www.mysqltutorial.org/perl-mysql/" title="Perl MySQL Tutorial">Perl</a></li></ul></li><li id="menu-item-5113" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-5113"><a href="https://www.mysqltutorial.org/tryit/">TryIt</a></li></ul><a class="switch-theme" title="Toggle dark mode" href="#"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="dark-mode-icon" viewBox="0 0 16 16"><path d="M6 .278a.768.768 0 0 1 .08.858 7.208 7.208 0 0 0-.878 3.46c0 4.021 3.278 7.277 7.318 7.277.527 0 1.04-.055 1.533-.16a.787.787 0 0 1 .81.316.733.733 0 0 1-.031.893A8.349 8.349 0 0 1 8.344 16C3.734 16 0 12.286 0 7.71 0 4.266 2.114 1.312 5.124.06A.752.752 0 0 1 6 .278zM4.858 1.311A7.269 7.269 0 0 0 1.025 7.71c0 4.02 3.279 7.276 7.319 7.276a7.316 7.316 0 0 0 5.205-2.162c-.337.042-.68.063-1.029.063-4.61 0-8.343-3.714-8.343-8.29 0-1.167.242-2.278.681-3.286z"/><path d="M10.794 3.148a.217.217 0 0 1 .412 0l.387 1.162c.173.518.579.924 1.097 1.097l1.162.387a.217.217 0 0 1 0 .412l-1.162.387a1.734 1.734 0 0 0-1.097 1.097l-.387 1.162a.217.217 0 0 1-.412 0l-.387-1.162A1.734 1.734 0 0 0 9.31 6.593l-1.162-.387a.217.217 0 0 1 0-.412l1.162-.387a1.734 1.734 0 0 0 1.097-1.097l.387-1.162zM13.863.099a.145.145 0 0 1 .274 0l.258.774c.115.346.386.617.732.732l.774.258a.145.145 0 0 1 0 .274l-.774.258a1.156 1.156 0 0 0-.732.732l-.258.774a.145.145 0 0 1-.274 0l-.258-.774a1.156 1.156 0 0 0-.732-.732l-.774-.258a.145.145 0 0 1 0-.274l.774-.258c.346-.115.617-.386.732-.732L13.863.1z"/></svg><svg  xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="light-mode-icon" viewBox="0 0 16 16"><path d="M8 11a3 3 0 1 1 0-6 3 3 0 0 1 0 6zm0 1a4 4 0 1 0 0-8 4 4 0 0 0 0 8zM8 0a.5.5 0 0 1 .5.5v2a.5.5 0 0 1-1 0v-2A.5.5 0 0 1 8 0zm0 13a.5.5 0 0 1 .5.5v2a.5.5 0 0 1-1 0v-2A.5.5 0 0 1 8 13zm8-5a.5.5 0 0 1-.5.5h-2a.5.5 0 0 1 0-1h2a.5.5 0 0 1 .5.5zM3 8a.5.5 0 0 1-.5.5h-2a.5.5 0 0 1 0-1h2A.5.5 0 0 1 3 8zm10.657-5.657a.5.5 0 0 1 0 .707l-1.414 1.415a.5.5 0 1 1-.707-.708l1.414-1.414a.5.5 0 0 1 .707 0zm-9.193 9.193a.5.5 0 0 1 0 .707L3.05 13.657a.5.5 0 0 1-.707-.707l1.414-1.414a.5.5 0 0 1 .707 0zm9.193 2.121a.5.5 0 0 1-.707 0l-1.414-1.414a.5.5 0 0 1 .707-.707l1.414 1.414a.5.5 0 0 1 0 .707zM4.464 4.465a.5.5 0 0 1-.707 0L2.343 3.05a.5.5 0 1 1 .707-.707l1.414 1.414a.5.5 0 0 1 0 .708z"/></svg></a><button class="menu-toggle" aria-controls="primary-menu" aria-expanded="false" aria-label="Primary Menu"></button></nav></div></header><div class="left-column"><div class="sticky"><div class="evolution-ad-slot" data-evolution-ad-slot data-evolution-ad-id="10912"><div data-aaad='true' data-aa-adunit='/21722279357/200x600_ob_mysqltutorial_desk'></div></div></div></div><main id="primary" class="site-main"><p class="breadcrumbs"><span><span><a href="https://www.mysqltutorial.org/">Home</a></span> » <span class="breadcrumb_last" aria-current="page">MySQL Full-Text Search</span></span></p><article id="post-12573" class="post-12573 page type-page status-publish hentry"><header class="entry-header"><h1 class="entry-title">MySQL Full-Text Search</h1></header><div class="entry-content"><div class="evolution-ad-slot" data-evolution-ad-slot data-evolution-ad-id="7617"><div id="alternative_content_top">
73<div class="ads ad-336"><div data-aaad='true' data-aa-adunit='/21722279357/336x280_OB_mysqltutorial_3_M'></div></div></div><div style="margin:18px 0 28px;"><a
74    href="https://apps.apple.com/us/app/savigo-savings-goals/id6756600696?utm_source=sqltutorial&utm_medium=inline&utm_campaign=savigo"
75    target="_blank"
76    rel="noopener noreferrer"
77    aria-label="Get Savigo for iPhone"
78    style="
79      display:flex;
80      align-items:center;
81      flex-wrap:wrap;
82      gap:14px;
83      padding:16px;
84      border:1px solid var(--border-color);
85      border-radius:12px;
86      color:inherit;
87      text-decoration:none;
88    "
89  ><img
90      src="https://www.duypham.app/wp-content/uploads/2026/08/savigo-logo-mark.svg"
91      alt="Savigo"
92      width="48"
93      height="48"
94      loading="lazy"
95      style="
96        display:block;
97        width:48px;
98        height:48px;
99        border-radius:12px;
100        flex:0 0 48px;
101      "
102    ><div style="flex:1 1 260px;min-width:0;"><div
103        style="
104          font-size:16px;
105          line-height:1.35;
106          font-weight:700;
107          letter-spacing:-0.01em;
108        "
109      >
110        You organize your data. Now organize your savings.
111      </div><div
112        style="
113          margin-top:4px;
114          font-size:13px;
115          line-height:1.5;
116          opacity:.7;
117        "
118      >
119        Set savings goals, track your progress, and stay on course.
120      </div></div><span
121      class="savigo-action"
122      style="
123        display:inline-flex;
124        align-items:center;
125        justify-content:center;
126        flex:0 0 auto;
127        min-height:36px;
128        padding:0 15px;
129        border:1px solid #12b981;
130        border-radius:999px;
131        background-color:#12b981;
132        color:#ffffff;
133        font-size:13px;
134        line-height:1;
135        font-weight:700;
136        white-space:nowrap;
137        box-shadow:0 2px 6px rgba(18,185,129,.22);
138        transition:
139          background-color .18s ease,
140          border-color .18s ease,
141          box-shadow .18s ease,
142          transform .18s ease;
143      "
144    >
145      Get Savigo for iPhone&nbsp;<span aria-hidden="true">›</span></span></a></div>
146
147<style>
148  a:hover .savigo-action,
149  a:focus-visible .savigo-action {
150    background-color:#0fa572 !important;
151    border-color:#0fa572 !important;
152    box-shadow:0 4px 10px rgba(18,185,129,.3) !important;
153    transform:translateY(-1px);
154  }
155
156  a:active .savigo-action {
157    transform:translateY(0);
158    box-shadow:0 2px 5px rgba(18,185,129,.22) !important;
159  }
160
161  @media (prefers-reduced-motion: reduce) {
162    .savigo-action {
163      transition:none !important;
164    }
165  }
166</style></div><p class="wp-block-paragraph">MySQL full-text search is an efficient way to perform complex searches within the text data stored in the database.</p><p class="wp-block-paragraph">The MySQL full-text search allows you to search natural language text rather than matching patterns. It goes beyond the traditional <code>LIKE</code> operator and regular expression searches.</p><p class="wp-block-paragraph">The <a href="https://www.mysqltutorial.org/mysql-basics/mysql-like/">LIKE</a> operator is commonly used for basic string pattern matching with the support of simple wildcard characters such as % (matches any sequence of characters) and _ (matches any single character. The LIKE is simple but may not be efficient for complex text searches on large datasets.</p><p class="wp-block-paragraph">The <a href="https://www.mysqltutorial.org/mysql-regular-expressions/">regular expressions</a> (regex) offer complex and flexible search patterns so that you can control the search criteria in greater detail. However, constructing and interpreting regex patterns can be complex. Similar to the <code>LIKE</code> operator, the regex has performance issues with large datasets.</p><p class="wp-block-paragraph">MySQL full-text search uses a sophisticated algorithm that considers word relevance, word proximity, and the context of the search terms to provide more accurate results. </p><p class="wp-block-paragraph">MySQL full-text search supports advanced search features such as boolean operators, phrase searches, and sorting the search result by relevance. In addition, it comes with built-in stopword removal and enables custom dictionaries and word stemming for enhanced 
166search capability. </p><p class="wp-block-paragraph">More importantly, the full-text search is optimized for large datasets and generally faster than the LIKE operator and regular expressions.</p><h2 class="wp-block-heading" id='mysql-full-text-search-features'>MySQL full-text search features <a href="#mysql-full-text-search-features" class="anchor" id="mysql-full-text-search-features" title="Anchor for MySQL full-text search features">#</a></h2><p class="wp-block-paragraph">The following are some key features of MySQL full-text search:</p><ul class="wp-block-list"><li><strong>Native SQL-like interface</strong>: Provides the SQL-like statement to perform full-text searches.</li><li><strong>Fully dynamic index</strong>: Updates the index of the text column automatically whenever the data of that column changes.</li><li><strong>Moderate index size</strong>: The size of a&nbsp;<code>FULLTEXT</code>&nbsp;index is relatively small.</li><li><strong>Speed</strong>: It is fast to search based on complex search queries.</li></ul><p class="note wp-block-paragraph">Notice that MySQL supports a full-text index only for <a href="https://www.mysqltutorial.org/mysql-administration/mysql-myisam/">MyISAM</a> and <a href="https://www.mysqltutorial.org/mysql-administration/mysql-innodb-storage-engine/">InnoDB</a> tables.</p><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained"><h2 class="wp-block-heading" id='mysql-full-text-search-tutorial'>MySQL Full-Text search tutorial <a href="#mysql-full-text-search-tutorial" class="anchor" id="mysql-full-text-search-tutorial" title="Anchor for MySQL Full-Text search tutorial">#</a></h2><ul class="wp-block-list"><li><a href="https://www.mysqltutorial.org/mysql-full-text-search/mysql-full-text-index/">Creating full-text index</a> &#8211; learn how to create a full-text index to perform efficient full-text searches.</li><li><a href="https://www.mysqltutorial.org/mysql-full-text-search/mysql-match-against/">Performing full-text searches with MATCH() and AGAINST() functions</a> &#8211; show you how to use the MATCH() and AGAINST() functions to perform full-text searches.</li><li><a href="https://www.mysqltutorial.org/mysql-full-text-search/mysql-natural-language-full-text-searches/">Natural Language Full-Text Searches</a> &#8211; In natural language search, MySQL looks for documents relevant to the free-text natural human language query.</li><li><a href="https://www.mysqltutorial.org/mysql-full-text-search/mysql-boolean-full-text-searches/">Boolean Full-Text Searches</a> &#8211; You will learn about MySQL Boolean full-text search and its main features. We will give you some examples to help you understand the concept better.</li><li><a href="https://www.mysqltutorial.org/mysql-full-text-search/mysql-query-expansion/">Query Expansion</a> &#8211; We show you an essential feature of MySQL full-text search which is known as Query Expansion.</li><li><a href="https://www.mysqltutorial.org/mysql-full-text-search/mysql-ngram-full-text-parser/">Using MySQL ngram Full-Text Parser</a> &#8211; show you how to use ngram full-text parser to support full-text searches for ideographic languages such as Chinese, Japanese, Korean, etc.</li><li><a href="https://www.mysqltutorial.org/mysql-full-text-search/mysql-full-text-index-performance/">Optimizing full-text search performance</a>  &#8211; guide you on how to optimize the full-text search performance.</li></ul></div></div><section class="hfb-container hfb-style-minimal hfb-layout-inline hfb-align-center" data-post-id="12573" aria-label="Page feedback"><div class="hfb-question"><p class="hfb-message">Was this tutorial helpful?</p><div class="hfb-buttons" role="group" aria-label="Was this tutorial helpful?"><button type="button" class="hfb-btn hfb-btn-yes" data-sentiment="positive" aria-pressed="false"><svg class="hfb-icon" viewBox="0 0 12 12" fill="none" aria-hidden="true" focusable="false"><path d="M3.5 11H2a1 1 0 0 1-1-1V6.5a1 1 0 0 1 1-1h1.5m3.5-1v-2A1.5 1.5 0 0 0 5.5 1l-2 4.5V11h5.64a1 1 0 0 0 1-.85l.69-4.5a1 1 0 0 0-1-1.15H7Z" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"/></svg><span>Yes</span></button><button type="button" class="hfb-btn hfb-btn-no" data-sentiment="negative" aria-pressed="false">
166<svg class="hfb-icon" viewBox="0 0 12 12" fill="none" aria-hidden="true" focusable="false"><path d="M3.5 1H2a1 1 0 0 0-1 1v3.5a1 1 0 0 0 1 1h1.5m3.5 1v2A1.5 1.5 0 0 1 5.5 11l-2-4.5V1h5.64a1 1 0 0 1 1 .85l.69 4.5a1 1 0 0 1-1 1.15H7Z" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"/></svg><span>No</span></button></div></div><div class="hfb-form-container" hidden><form class="hfb-feedback-form" novalidate><label for="hfb-feedback-message-12573-1">Please help us to improve</label>
167                    <textarea id="hfb-feedback-message-12573-1" name="feedback_message" rows="4" maxlength="1000"></textarea>
168                    <div class="hfb-form-actions"><button type="submit" class="hfb-btn hfb-btn-submit">Submit Feedback</button><button type="button" class="hfb-btn-cancel">Cancel</button></div></form></div><div class="hfb-status" role="status" aria-live="polite"></div><div class="hfb-thank-you" hidden><p>Thank you for your feedback!</p></div><input type="hidden" class="hfb-form-display-mode" value="negative"></section><div class="evolution-ad-slot" data-evolution-ad-slot data-evolution-ad-id="7608"><div class="ad ad-336"><div data-aaad='true' data-aa-adunit='/21722279357/336x280_OB_mysqltutorial.org_2'></div></div></div></div></article><nav class="page-nav" aria-label="Page navigation"><div class="prev-page"><a class="prev-page-anchor" href="https://www.mysqltutorial.org/mysql-json/mysql-json_unquote/"><div class="page-nav-arrow" aria-hidden="true"><img src="https://www.mysqltutorial.org/wp-content/themes/evolution/img/left.svg" height="32" width="32" class="icon-prev-page" alt=""></div><div class="page-nav-main page-nav-first"><div class="page-nav-title">Previous</div><div class="page-title">MySQL JSON_UNQUOTE() Function</div></div></a></div><div class="next-page"><a class="next-page-anchor" href="https://www.mysqltutorial.org/mysql-full-text-search/mysql-full-text-index/"><div class="page-nav-main page-nav-second"><div class="page-nav-title">Up next</div><div class="page-title">MySQL Full-Text Index</div></div><div class="page-nav-arrow" aria-hidden="true"><img src="https://www.mysqltutorial.org/wp-content/themes/evolution/img/right.svg" height="32" width="32" class="icon-next-page" alt=""></div></a></div></nav></main><aside id="secondary" class="widget-area sidebar"><section id="evolution_ad-4" class="widget widget_evolution_ad"><div class="evolution-ad-slot" data-evolution-ad-slot data-evolution-ad-id="7612"><div class="ad ad-300"><div data-aaad='true' data-aa-adunit='/21722279357/300x250_OB_mysqltutorial.org'></div></div></div></section><section id="search-2" class="widget widget_search"><div class="smart-search-native smart-search-native--widget"><div class="smart-search smart-search--overlay smart-search--comfortable smart-search--scheme-auto smart-search--appearance-follow-theme smart-search--shape-soft" style="--ss-radius:10px;--ss-accent:#2563eb;--ss-custom-bg:#ffffff;--ss-custom-fg:#172033;--ss-custom-border:#d0d5dd;--ss-light-box-background:#ffffff;--ss-light-box-text:#172033;--ss-light-box-placeholder:#667085;--ss-light-box-border:#d0d5dd;--ss-light-popup-background:#ffffff;--ss-light-popup-text:#172033;--ss-light-popup-muted:#667085;--ss-light-popup-border:#d0d5dd;--ss-light-accent:#2563eb;--ss-light-hover:#eff6ff;--ss-dark-box-background:#2e2e2e;--ss-dark-box-text:#e3e3e3;--ss-dark-box-placeholder:#b8b8b8;--ss-dark-box-border:#454545;--ss-dark-popup-background:#171717;--ss-dark-popup-text:#e3e3e3;--ss-dark-popup-muted:#a9a9a9;--ss-dark-popup-border:#454545;--ss-dark-accent:#4db2ff;--ss-dark-hover:#242424;--ss-box-border-width:1px;--ss-popup-border-width:1px;--ss-box-radius:10px;--ss-popup-radius:12px;--ss-custom-shadow:0 16px 40px rgba(16,24,40,.18)" data-smart-search data-config="{&quot;indexUrl&quot;:&quot;\/wp-content\/uploads\/smart-search\/search-index.bb46435cfbc3.json&quot;,&quot;appUrl&quot;:&quot;\/wp-content\/plugins\/smart-site-search\/assets\/js\/search-app.js&quot;,&quot;mode&quot;:&quot;overlay&quot;,&quot;nativeFallbackUrl&quot;:&quot;https:\/\/www.mysqltutorial.org\/?s=&quot;,&quot;appearanceMode&quot;:&quot;follow-theme&quot;,&quot;customSearchSelector&quot;:&quot;&quot;,&quot;queryParameter&quot;:&quot;q&quot;,&quot;minQueryLength&quot;:2,&quot;maxResults&quot;:8,&quot;threshold&quot;:0.320000000000000006661338147750939242541790008544921875,&quot;keyboardShortcuts&quot;:true,&quot;highlightTitle&quot;:true,&quot;openNewTab&quot;:false,&quot;loadingStrategy&quot;:&quot;interaction&quot;,&quot;enableTypeFilters&quot;:true,&quot;enableSnippets&quot;:true,&quot;snippetLength&quot;:180,&quot;synonyms&quot;:[],&quot;analytics&quot;:{&quot;enabled&quot;:false,&quot;provider&quot;:&quot;browser-event&quot;,&quot;minLength&quot;:2},&quot;locale&quot;:&quot;en_US&quot;,&quot;localeFiltering&quot;:false,&quot;messages&quot;:{&quot;loading&quot;:&quot;Loading search\u2026&quot;,&quot;noResults&quot;:&quot;No results found.&quot;,&quot;error&quot;:&quot;Search could not be loaded.&quot;,&quot;allTypes&quot;:&quot;All content&quot;,&quot;results&quot;:&quot;results&quot;,&quot;pages&quot;:&quot;Pages&quot;,&quot;startTyping&quot;:&quot;Start typing to search.&quot;,&quot;recentSearches&quot;:&quot;Recent searches&quot;,&quot;clearRecent&quot;:&quot;Clear&quot;}}"><label class="screen-reader-text" for="smart-search-2">Search</label><div class="smart-search__field"><span class="smart-search__icon" aria-hidden="true"></span><input id="smart-search-2" class="smart-search__input" type="search" placeholder="Search this site…" autocomplete="off" role="combobox" aria-autocomplete="list" aria-expanded="false" aria-controls="smart-search-2-results"><button class="smart-search__clear" type="button" aria-label="Clear search" hidden>×</button></div><div id="smart-search-2-results" class="smart-search__panel" role="listbox" hidden></div><div class="smart-search__status screen-reader-text" aria-live="polite"></div></div></div></section><section id="nav_menu-66" class="widget widget_nav_menu"><h2 class="widget-title">Getting Started</h2><div class="menu-mysql-quick-start-container"><ul id="menu-mysql-quick-start" class="menu"><li id="menu-item-4209" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-4209"><a href="https://www.mysqltutorial.org/getting-started-with-mysql/what-is-mysql/">What Is MySQL?</a></li><li id="menu-item-2320" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2320"><a href="https://www.mysqltutorial.org/getting-started-with-mysql/install-mysql/">Install MySQL Database Server</a></li><li id="menu-item-9016" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-9016"><a href="https://www.mysqltutorial.org/getting-started-with-mysql/connect-to-mysql-server/">Connect to MySQL Server</a></li><li id="menu-item-2324" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2324"><a href="https://www.mysqltutorial.org/getting-started-with-mysql/mysql-sample-database/">Download MySQL Sample Database</a></li><li id="menu-item-2321" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2321"><a href="https://www.mysqltutorial.org/getting-started-with-mysql/how-to-load-sample-database-into-mysql-database-server/" title="How to Load Sample Database into MySQL Database Server">Load Sample Database</a></li></ul></div></section><section id="nav_menu-7" class="widget widget_nav_menu"><h2 class="widget-title">Querying Data</h2><div class="menu-basics-querying-data-container"><ul id="menu-basics-querying-data" class="menu"><li id="menu-item-13787" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13787"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-select-from/" title="MySQL SELECT FROM">SELECT FROM</a></li><li id="menu-item-13788" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13788"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-select/" title="MySQL SELECT">SELECT</a></li><li id="menu-item-13786" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13786"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-order-by/" title="MySQL ORDER BY">ORDER BY</a></li><li id="menu-item-11761" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11761"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-where/" title="MySQL WHERE">WHERE</a></li><li id="menu-item-13785" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13785"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-distinct/" title="MySQL DISTINCT">SELECT DISTINCT</a></li><li id="menu-item-11763" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11763"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-and/" title="MySQL AND Operator">AND</a></li><li id="menu-item-11764" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11764"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-or/" title="MySQL OR Operator">OR</a></li><li id="menu-item-11765" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11765"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-in/" title="MySQL IN">IN</a></li><li id="menu-item-11927" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11927"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-not-in/" title="MySQL NOT IN">NOT IN</a></li><li id="menu-item-13784" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13784"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-between/" title="MySQL BETWEEN">BETWEEN</a></li>
168<li id="menu-item-13783" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13783"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-like/" title="MySQL LIKE">LIKE</a></li><li id="menu-item-13782" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13782"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-limit/" title="MySQL LIMIT">LIMIT</a></li><li id="menu-item-13781" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13781"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-is-null/" title="MySQL IS NULL">IS NULL</a></li><li id="menu-item-11770" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11770"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-alias/" title="MySQL Alias">Table &#038; Column Aliases</a></li><li id="menu-item-11771" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11771"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-join/" title="MySQL Joins">Joins</a></li><li id="menu-item-13780" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13780"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-inner-join/" title="MySQL INNER JOIN">INNER JOIN</a></li><li id="menu-item-13779" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13779"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-left-join/" title="MySQL LEFT JOIN">LEFT JOIN</a></li><li id="menu-item-11774" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11774"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-right-join/" title="MySQL RIGHT JOIN">RIGHT JOIN</a></li><li id="menu-item-11775" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11775"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-self-join/" title="MySQL Self Join">Self Join</a></li><li id="menu-item-11776" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11776"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-cross-join/" title="MySQL CROSS JOIN">CROSS JOIN</a></li><li id="menu-item-11777" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11777"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-group-by/" title="MySQL GROUP BY">GROUP BY</a></li><li id="menu-item-11778" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11778"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-having/" title="MySQL HAVING">HAVING</a></li><li id="menu-item-13789" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13789"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-having-count/" title="MySQL HAVING COUNT">HAVING COUNT</a></li><li id="menu-item-11779" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11779"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-rollup/" title="MySQL ROLLUP">ROLLUP</a></li><li id="menu-item-11780" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11780"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-subquery/" title="MySQL Subquery">Subquery</a></li><li id="menu-item-11781" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11781"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-derived-table/" title="MySQL Derived Table">Derived Tables</a></li><li id="menu-item-11782" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-11782"><a href="https://www.mysqltutorial.org/mysql-exists/">EXISTS</a></li><li id="menu-item-11784" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11784"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-except/" title="MySQL EXCEPT operator">EXCEPT</a></li><li id="menu-item-11785" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11785"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-intersect/" title="MySQL INTERSECT">INTERSECT</a></li></ul></div></section><section id="evolution_ad-5" class="widget widget_evolution_ad"><div class="evolution-ad-slot" data-evolution-ad-slot data-evolution-ad-id="7604"><div class="ad ad-300"><div data-aaad='true' data-aa-adunit='/21722279357/300x250_OB_mysqltutorial.org_2'></div></div></div></section><section id="nav_menu-8" class="widget widget_nav_menu"><h2 class="widget-title">Managing Databases</h2><div class="menu-basics-manage-databases-container"><ul id="menu-basics-manage-databases" class="menu"><li id="menu-item-10428" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10428"><a href="https://www.mysqltutorial.org/mysql-basics/selecting-a-mysql-database-using-use-statement/" title="Selecting a MySQL Database Using USE Statement">Select a Database</a></li><li id="menu-item-10429" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10429"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-create-database/" title="MySQL Create Database">Create Databases</a></li><li id="menu-item-10430" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10430"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-drop-database/" title="MySQL DROP DATABASE">Drop Databases</a></li></ul></div></section><section id="nav_menu-52" class="widget widget_nav_menu"><h2 class="widget-title">Managing Tables</h2><div class="menu-basics-tables-container"><ul id="menu-basics-tables" class="menu"><li id="menu-item-10432" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10432"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-create-table/" title="CREATE TABLE">Create Tables</a></li><li id="menu-item-10908" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10908"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-auto_increment/" title="MySQL AUTO_INCREMENT">AUTO_INCREMENT</a></li><li id="menu-item-10434" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10434"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-rename-table/" title="MySQL RENAME TABLE">Rename Tables</a></li><li id="menu-item-10438" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10438"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-add-column/" title="How to Add Columns to a Table Using MySQL ADD COLUMN Statement">Add Columns</a></li><li id="menu-item-10436" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10436"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-drop-column/" title="MySQL DROP COLUMN">Drop Columns</a></li><li id="menu-item-10439" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10439"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-drop-table/" title="MySQL DROP TABLE">Drop Tables</a></li><li id="menu-item-10440" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10440"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-temporary-table/" title="MySQL Temporary Table">Temporary Tables</a></li><li id="menu-item-10442" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10442"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-generated-columns/" title="How To Use The MySQL Generated Columns">Generated Columns</a></li></ul></div></section><section id="nav_menu-51" class="widget widget_nav_menu"><h2 class="widget-title">MySQL Constraints</h2><div class="menu-basics-constraints-container"><ul id="menu-basics-constraints" class="menu"><li id="menu-item-10416" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10416"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-primary-key/" title="MySQL Primary Key">Primary Key</a></li><li id="menu-item-10415" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10415"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-foreign-key/" title="MySQL Foreign Key">Foreign Key</a></li><li id="menu-item-10410" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10410"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-disable-foreign-key-checks/" title="MySQL Disable Foreign Key Checks">Disable Foreign Key Checks</a></li><li id="menu-item-10414" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10414"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-unique-constraint/" title="MySQL UNIQUE Constraint">UNIQUE Constraint</a></li><li id="menu-item-10417" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10417"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-not-null-constraint/" title="MySQL NOT NULL Constraint">NOT NULL Constraint</a></li><li id="menu-item-10412" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10412"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-default/" title="MySQL DEFAULT">DEFAULT Constraint</a></li><li id="menu-item-10413" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-10413"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-check-constraint/" title="MySQL CHECK Constraint">CHECK Constraint</a></li></ul></div></section><section id="evolution_ad-6" class="widget widget_evolution_ad"><div class="evolution-ad-slot" data-evolution-ad-slot data-evolution-ad-id="7606"><div class="ad ad-300"><div data-aaad='true' data-aa-adunit='/21722279357/300x250_OB_mysqltutorial.org_3'></div></div></div></section><section id="nav_menu-62" class="widget widget_nav_menu"><h2 class="widget-title">Insert data</h2><div class="menu-basics-inserting-container"><ul id="menu-basics-inserting" class="menu"><li id="menu-item-13812" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13812"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-insert/" title="MySQL INSERT">Insert Into</a></li><li id="menu-item-11826" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11826"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-insert-multiple-rows/" title="MySQL Insert Multiple Rows">Insert Multiple Rows</a></li><li id="menu-item-11827" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11827"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-insert-into-select/" title="MySQL INSERT INTO SELECT">INSERT INTO SELECT</a></li><li id="menu-item-11828" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11828"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-insert-or-update-on-duplicate-key-update/" title="MySQL Insert On Duplicate Key Update">Insert On Duplicate Key Update</a></li><li id="menu-item-11829" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11829"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-insert-ingore/" title="MySQL INSERT IGNORE Statement">INSERT IGNORE</a></li><li id="menu-item-11923" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11923"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-insert-datetime/" title="MySQL Insert DateTime">Insert DateTimes</a></li><li id="menu-item-11922" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11922"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-insert-date/" title="MySQL Insert Date">Insert Dates</a></li></ul></div></section><section id="nav_menu-63" class="widget widget_nav_menu"><h2 class="widget-title">Update Data</h2><div class="menu-basics-updating-container"><ul id="menu-basics-updating" class="menu"><li id="menu-item-13790" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13790"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-update/" title="MySQL UPDATE">UPDATE</a></li><li id="menu-item-11870" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11870"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-update-join/" title="MySQL UPDATE JOIN">UPDATE JOIN</a></li></ul></div></section><section id="nav_menu-64" class="widget widget_nav_menu"><h2 class="widget-title">Delete Data</h2><div class="menu-basics-deleting-container"><ul id="menu-basics-deleting" class="menu"><li id="menu-item-11917" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11917"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-delete-join/" title="MySQL DELETE JOIN">DELETE JOIN</a></li><li id="menu-item-11918" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11918"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-on-delete-cascade/" title="MySQL ON DELETE CASCADE">
168ON DELETE CASCADE</a></li><li id="menu-item-11934" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11934"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-truncate-table/" title="MySQL TRUNCATE TABLE">TRUNCATE TABLE</a></li></ul></div></section><section id="nav_menu-65" class="widget widget_nav_menu"><h2 class="widget-title">MySQL Transactions</h2><div class="menu-basics-locking-container"><ul id="menu-basics-locking" class="menu"><li id="menu-item-11921" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11921"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-table-locking/" title="MySQL Table Locking">Table Locking</a></li></ul></div></section><section id="nav_menu-35" class="widget widget_nav_menu"><h2 class="widget-title">MySQL Data Types</h2><div class="menu-basics-data-types-container"><ul id="menu-basics-data-types" class="menu"><li id="menu-item-6470" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6470"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-bit/" title="Pramatic Uses of MySQL BIT Data Type">BIT</a></li><li id="menu-item-6468" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6468"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-int/" title="MySQL INT Data Type">INT</a></li><li id="menu-item-6469" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6469"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-boolean/" title="An Introduction to MySQL BOOLEAN Data Type">BOOLEAN</a></li><li id="menu-item-6471" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6471"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-decimal/" title="MySQL DECIMAL Data Type">DECIMAL</a></li><li id="menu-item-6475" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6475"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-datetime/" title="MySQL DATETIME Data Type">DATETIME</a></li><li id="menu-item-6474" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6474"><a href="https://www.mysqltutorial.org/mysql-basics/understanding-mysql-timestamp/" title="MySQL TIMESTAMP">TIMESTAMP</a></li><li id="menu-item-6472" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6472"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-date/" title="MySQL DATE Data Type">DATE</a></li><li id="menu-item-6473" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6473"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-time/" title="MySQL TIME Data Type">TIME</a></li><li id="menu-item-6478" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6478"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-char-data-type/" title="MySQL CHAR Data Type">CHAR</a></li><li id="menu-item-6477" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6477"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-varchar/" title="The Essential Guide to MySQL VARCHAR Data Type">VARCHAR</a></li><li id="menu-item-11935" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11935"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-text/" title="MySQL TEXT Data Type">TEXT</a></li><li id="menu-item-11718" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11718"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-binary/" title="MySQL BINARY Data Type">BINARY</a></li><li id="menu-item-11717" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-11717"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-varbinary/" title="MySQL VARBINARY Data Type">VARBINARY</a></li><li id="menu-item-6476" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6476"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-enum/" title="A Comprehensive Guide to Using MySQL ENUM">ENUM</a></li><li id="menu-item-13858" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-13858"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-blob/" title="MySQL BLOB">BLOB</a></li></ul></div></section><section id="nav_menu-36" class="widget widget_nav_menu"><h2 class="widget-title">MySQL Globalization</h2><div class="menu-basics-globalization-container"><ul id="menu-basics-globalization" class="menu"><li id="menu-item-6670" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6670"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-character-set/" title="MySQL Character Set">MySQL Character Sets</a></li><li id="menu-item-6671" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6671"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-collation/">MySQL Collation</a></li></ul></div></section><section id="nav_menu-37" class="widget widget_nav_menu"><h2 class="widget-title">MySQL Import &#038; Export</h2><div class="menu-mysql-import-export-container"><ul id="menu-mysql-import-export" class="menu"><li id="menu-item-6672" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6672"><a href="https://www.mysqltutorial.org/mysql-basics/import-csv-file-mysql-table/">Import a CSV File Into a Table</a></li><li id="menu-item-6673" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6673"><a href="https://www.mysqltutorial.org/mysql-basics/mysql-export-table-to-csv/">Export a Table to a CSV File</a></li></ul></div></section><section id="evolution_ad-7" class="widget widget_evolution_ad"><div class="evolution-ad-slot" data-evolution-ad-slot data-evolution-ad-id="7610"><div class="ad ad-300"><div data-aaad='true' data-aa-adunit='/21722279357/300x250_OB_mysqltutorial_4'></div></div></div></section></aside><footer id="colophon" class="site-footer"><div class="site-footer-widgets"><div class="site-footer-sidebar widget"><h2 class="widget-title">About MySQL Tutorial Website</h2><div class="textwidget custom-html-widget"><div>
169MySQLTutorial.org helps you master MySQL quickly, easily, and with enjoyment. Our tutorials make learning MySQL a breeze.
170</div><p>
171	All MySQL tutorials are clear, practical and easy-to-follow. <a href="/about-us/">More About Us</a></p></div></div><div class="site-footer-sidebar widget"><h2 class="widget-title">Latest Tutorials</h2><ul><li><a href="https://www.mysqltutorial.org/mysql-administration/mysql-port/">MySQL Port</a></li><li><a href="https://www.mysqltutorial.org/mysql-basics/mysql-commands/">MySQL Commands</a></li><li><a href="https://www.mysqltutorial.org/mysql-administration/innodb_dedicated_server/">innodb_dedicated_server: Configure InnoDB Dedicated Server</a></li><li><a href="https://www.mysqltutorial.org/mysql-administration/innodb_flush_method/">innodb_flush_method: Configure InnoDB Flush Method</a></li><li><a href="https://www.mysqltutorial.org/mysql-administration/innodb_log_buffer_size/">innodb_log_buffer_size: Configure InnoDB Log Buffer Size</a></li><li><a href="https://www.mysqltutorial.org/mysql-administration/innodb_buffer_pool_chunk_size/">innodb_buffer_pool_chunk_size: Configure Buffer Pool Chunk Size</a></li><li><a href="https://www.mysqltutorial.org/mysql-administration/innodb_buffer_pool_instances/">innodb_buffer_pool_instances: Configuring Multiple Buffer Pool Instances for Improved Concurrency in MySQL</a></li><li><a href="https://www.mysqltutorial.org/mysql-administration/innodb_buffer_pool_size/">innodb_buffer_pool_size: Configure InnoDB Buffer Pool Size</a></li><li><a href="https://www.mysqltutorial.org/mysql-administration/mysql-innodb-architecture/">MySQL InnoDB Architecture</a></li><li><a href="https://www.mysqltutorial.org/mysql-administration/kill-process-in-mysql/">How to Kill a Process in MySQL</a></li></ul></div><div class="site-footer-sidebar widget"><h2 class="widget-title">Site Links</h2><div class="menu-site-links-container"><ul id="menu-site-links" class="menu"><li id="menu-item-9272" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-9272"><a href="https://www.mysqltutorial.org/donation/">Donation ❤️</a></li><li id="menu-item-1691" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1691"><a href="https://www.mysqltutorial.org/contact-us/">Contact Us</a></li><li id="menu-item-1740" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1740"><a href="https://www.mysqltutorial.org/about-us/">About</a></li><li id="menu-item-1693" class="nofollow menu-item menu-item-type-post_type menu-item-object-page menu-item-1693"><a href="https://www.mysqltutorial.org/privacy-policy/">Privacy Policy</a></li></ul></div><h2 class="widget-title">Others</h2><div class="menu-other-container"><ul id="menu-other" class="menu"><li id="menu-item-1706" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1706"><a href="https://www.mysqltutorial.org/mysql-cheat-sheet/">MySQL Cheat Sheet</a></li><li id="menu-item-1711" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1711"><a href="https://www.mysqltutorial.org/mysql-resources/">MySQL Resources</a></li><li id="menu-item-1709" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1709"><a href="https://www.mysqltutorial.org/mysql-books/" title="The Best MySQL Books For Developers &#038; DBAs">MySQL Books</a></li></ul></div></div></div><div class="site-info"><div class="textwidget custom-html-widget">
171Copyright &copy; 2008 - Present by <a href="https://www.mysqltutorial.org/">www.mysqltutorial.org</a>. All Rights Reserved.</div></div></div></footer></div>
172
173<script type="speculationrules">
174{"prefetch":[{"source":"document","where":{"and":[{"href_matches":"/*"},{"not":{"href_matches":["/wp-*.php","/wp-admin/*","/wp-content/uploads/*","/wp-content/*","/wp-content/plugins/*","/wp-content/themes/evolution/*","/*\\?(.+)"]}},{"not":{"selector_matches":"a[rel~=\"nofollow\"]"}},{"not":{"selector_matches":".no-prefetch, .no-prefetch a"}}]},"eagerness":"conservative"}]}
175</script>
vendor: 1 bytes, line 175
175
176<script id="hfb-frontend-js-extra">
177var hfbData = {"restUrl":"https://www.mysqltutorial.org/wp-json/helpful-feedback/v1/submit","settings":{"message_text":"Was this tutorial helpful?","yes_label":"Yes","no_label":"No","form_label":"Please help us to improve","submit_label":"Submit Feedback","cancel_label":"Cancel","thank_you_message":"Thank you for your feedback!","form_display_mode":"negative","enable_form":true,"enable_notifications":false,"notification_email":"[email protected]","block_style":"minimal","block_layout":"inline","content_alignment":"center","auto_display_enabled":true,"auto_display_post":false,"auto_display_page":true,"excluded_post_ids":[599,821,597,1737],"excluded_category_ids":[]}};
178//# sourceURL=hfb-frontend-js-extra
179</script>
vendor: 1 bytes, line 179
179
180<script defer id="hfb-frontend-js" src="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/4f5d51d1d3c7422a4759780dd60a1d47505a6ce899c8a38f600647ad9c06fedd.js"></script>
vendor: 1 bytes, line 180
180
181<script data-wp-strategy="defer" defer id="smart-search-fuse-js" src="https://www.mysqltutorial.org/wp-content/plugins/smart-site-search/assets/vendor/fuse/fuse.min.js?ver=7.1.0"></script>
vendor: 1 bytes, line 181
181
182<script data-wp-strategy="defer" defer id="smart-search-loader-js" src="https://www.mysqltutorial.org/wp-content/plugins/smart-site-search/assets/js/loader.js?ver=1789287369"></script>
vendor: 1 bytes, line 182
182
183<script defer id="ev-back-to-top-js" src="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/024922f436c6d4436b682f9e83d0c6367c6d48a03cd3175d4592bd54464510b6.js"></script>
vendor: 1 bytes, line 183
183
184<script defer id="ev-mode-js" src="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/0fc203da487b00de48db716f8b3dd8e2c4ba24f7aa1f03f488614241fb446146.js"></script>
vendor: 1 bytes, line 184
184
185<script defer id="ev-navbar-js" src="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/4eef569cf2c290b7cdecc6fc85c66c4221de64cd4d0b7712bdb1d76eb052dc4f.js"></script>
vendor: 1 bytes, line 185
185
186<script defer id="ev-mobile-menu-js" src="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/d291592c932823d2d5c7f7d2d56c9fb5c10219f2d24452b77bfc61b9f1cafa0e.js"></script>
vendor: 1 bytes, line 186
186
187<script defer id="ev-search-table-js" src="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/47d69b4f1968e54aaeb5cb711ac54fa21c82a8949fe1df45c08db8cf47dce1e7.js"></script>
vendor: 1 bytes, line 187
187
188<script defer id="ev-app-js" src="https://www.mysqltutorial.org/wp-content/uploads/essential-optimize/cache/800bb98420ebfae2e871bfb7aafe43ee228a1c842a8982306041d86559900545.js"></script>
188
189
190
191
192<script>(function(){function c(){var b=a.contentDocument||(a.contentWindow&&a.contentWindow.document);if(b){var d=b.createElement('script');d.innerHTML="window.__CF$cv$params={r:'a3b58f85fe5f2b8e',t:'MTc4OTQ1MzU5NA=='};var a=document.createElement('script');a.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js';document.getElementsByTagName('head')[0].appendChild(a);";b.getElementsByTagName('head')[0].appendChild(d)}}if(document.body){var a=document.createElement('iframe');a.height=1;a.width=1;a.style.position='absolute';a.style.top=0;a.style.left=0;a.style.border='none';a.style.visibility='hidden';document.body.appendChild(a);if('loading'!==document.readyState)c();else if(window.addEventListener)document.addEventListener('DOMContentLoaded',c);else{var e=document.onreadystatechange||function(){};document.onreadystatechange=function(b){e(b);'loading'!==document.readyState&&(document.onreadystatechange=e,c())}}}})();</script>
192<script type="module" src="https://static.cloudflareinsights.com/beacon.min.js/v31edd6df95cf4e85bb4c19e7a9bdbcba1788362987495" integrity="sha512-iIg7k2xntmwu6/uSb5tpc/hySgZc4eoL31yB29W6tJFo2akwjPWcEqnCEdJvGexCL0KEQwVYv5BlowfhVz26hg==" data-cf-beacon='{"version":"2024.11.0","token":"ec6924b2fdaf43af84f6fe3edaac7280","r":1,"spa":2}' crossorigin="anonymous"></script>
vendor: 1 bytes, line 192
192
193<script type="module" src="https://static.cloudflareinsights.com/beacon.min.js/v31edd6df95cf4e85bb4c19e7a9bdbcba1788362987495" integrity="sha512-iIg7k2xntmwu6/uSb5tpc/hySgZc4eoL31yB29W6tJFo2akwjPWcEqnCEdJvGexCL0KEQwVYv5BlowfhVz26hg==" data-cf-beacon='{"version":"2024.11.0","token":"ec6924b2fdaf43af84f6fe3edaac7280","r":1,"spa":2}' crossorigin="anonymous"></script>
vendor: 1 bytes, line 193
193
194<script>(function(){function c(){var b=a.contentDocument||(a.contentWindow&&a.contentWindow.document);if(b){var d=b.createElement('script');d.innerHTML="window.__CF$cv$params={r:'a4403f094ab5e079',t:'MTc5MDkwNzgxOA=='};var a=document.createElement('script');a.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js';document.getElementsByTagName('head')[0].appendChild(a);";b.getElementsByTagName('head')[0].appendChild(d)}}if(document.body){var a=document.createElement('iframe');a.height=1;a.width=1;a.style.position='absolute';a.style.top=0;a.style.left=0;a.style.border='none';a.style.visibility='hidden';document.body.appendChild(a);if('loading'!==document.readyState)c();else if(window.addEventListener)document.addEventListener('DOMContentLoaded',c);else{var e=document.onreadystatechange||function(){};document.onreadystatechange=function(b){e(b);'loading'!==document.readyState&&(document.onreadystatechange=e,c())}}}})();</script>
194</body></html>
195<!-- Smart Static | Build: ss-20260915-062301-qqdbki | Version: 1.5.8 | Generated: 2026-09-14T23:23:01-07:00 -->

Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.