René's URL Explorer Experiment

{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://sqlint.com/#organization","name":"SqlInt","url":"https://sqlint.com","logo":"https://sqlint.com/og-image.jpg","email":"support.sqlint@gmail.com","description":"SqlInt is a browser-based SQL practice and interview-preparation platform that also provides free client-side SQL tools for developers.","disambiguatingDescription":"SqlInt (sqlint.com) is a browser-based SQL practice and interview-preparation website with free client-side SQL tools - a web platform, not a command-line utility.","contactPoint":{"@type":"ContactPoint","contactType":"customer support","email":"support.sqlint@gmail.com","availableLanguage":["en"]},"subjectOf":[{"@type":"WebPage","url":"https://sqlint.com/about","name":"About SqlInt"}],"sameAs":[]},{"@type":"WebSite","@id":"https://sqlint.com/#website","url":"https://sqlint.com","name":"SqlInt","description":"SqlInt is a browser-based SQL practice and interview-preparation platform that also provides free client-side SQL tools for developers.","publisher":{"@id":"https://sqlint.com/#organization"}}]}

{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://sqlint.com"},{"@type":"ListItem","position":2,"name":"Learn SQL","item":"https://sqlint.com/learn-sql"},{"@type":"ListItem","position":3,"name":"String Functions","item":"https://sqlint.com/learn-sql/string-functions"}]}

{"@context":"https://schema.org","@type":"FAQPage","mainEntity":[{"@type":"Question","name":"LENGTH vs CHAR_LENGTH — why do they differ?","acceptedAnswer":{"@type":"Answer","text":"LENGTH counts bytes, CHAR_LENGTH counts characters. With UTF-8, 'ä' is one character but two bytes, so names like 'Jürgen' make the two functions disagree. For human-facing strings, CHAR_LENGTH (or CHARACTER_LENGTH) is almost always what you meant."}},{"@type":"Question","name":"Does 'abc' TRIM to 'abc' — and what about empty vs NULL?","acceptedAnswer":{"@type":"Answer","text":"TRIM removes spaces (and optionally other characters) from both ends, so '  abc  ' → 'abc'. But '' (empty string) is not NULL: LENGTH('') is 0, while LENGTH(NULL) is NULL. Cleaning pipelines must handle both separately — trimming never turns an empty string into NULL."}}]}

{"@context":"https://schema.org","@type":"LearningResource","@id":"https://sqlint.com/learn-sql/string-functions#learning-resource","name":"String Functions — SQL Tutorial with Examples","description":"Learn SQL String Functions. Includes syntax, examples, mistakes, and interview tips.","speakable":{"@type":"SpeakableSpecification","cssSelector":["h1",".topic-explanation"]},"citation":["https://www.postgresql.org/docs/current/sql.html","https://sqlite.org/lang.html","https://www.postgresql.org/docs/current/tutorial.html"],"isPartOf":{"@id":"https://sqlint.com/learn-sql#course"},"educationalLevel":"Intermediate","teaches":["Syntax: CONCAT(s1, s2)\nUPPER(s) / LOWER(s)\nLENGTH(s)\nSUBSTRING(s, start, length)\nTRIM(s) / LTRIM(s) / RTRIM(","Core concept: SQL has built-in string functions for data cleaning and transformation. Common ones: CONCAT (join st","Common mistakes: Function names differ by database. SUBSTRING vs SUBSTR, CHARINDEX (SQL Server) vs POSITION (MySQL/Po","Interview tips: Data cleaning questions are common in analytics interviews. Practice extracting domain from email, p"],"timeRequired":"10 mins","about":{"@type":"Thing","name":"SQL","description":"Structured Query Language"},"audience":{"@type":"EducationalAudience","educationalRole":"student"},"author":{"@type":"Organization","@id":"https://sqlint.com/#organization","name":"SqlInt"},"url":"https://sqlint.com/learn-sql/string-functions"}