note

substr instr trim について

この3つの関数は、SQLiteにおけるテキスト（文字列）データクレンジングの「三種の神器」とも言える非常に強力な関数です。仕組みをマスターすると、どんな複雑な文字列整形も自由自在に ...
blog.csdn

SQL substring字符串截取函数详解：语法差异、数据清洗实战与避坑指南

文章浏览阅读22次。字符串截取是SQL开发中最常见的文本处理需求，substring函数通过指定起始位置和截取长度，能够从任意字段中快速提取需要的子串。不同数据库在实现细节上存在明显差异，例如MySQL支持SUBSTRING_INDEX按分隔符切分，SQL Server对起始位置和长度边界有严格处理，Oracle则允许负数位置从 ...
note

[SQL Standard] Practical Methods for Searching the Occurrence Position of Specific Keywords in Text Data

Mechanism for Obtaining the Position Where a Specified Keyword First Appears The SQL standard defines a dedicated built-in function that scans for a keyword (substring) you want to search for within ...
bilibili

SQL 字符串裁剪神器：SUBSTRING() 3分钟教你提取关键数据！

简介： 数据库里一堆长字符串，只想取中间的身份证号、手机号或日期怎么办？ 别再手动导 Excel 了，一个 SUBSTRING() 函数全搞定！ 本集重点： 三个参数：str（目标）、pos（从哪开始）、len ...
Edutopia

Making Use of a Worked Example to Improve Learning

It’s a familiar moment in math class—students are asked to solve a problem, and some jump in confidently while others freeze, unsure where to begin. When students don’t yet have a clear mental model ...
GitHub

XiYan-SQL: A Multi-Generator Ensemble Framework for Text-to-SQL

Oct. 30, 2025 🌟 We are excited to release the XiYan-SQL training framework XiYan-SQLTraining! This framework is primarily designed for the training of SQL/general LLMs and includes capabilities such ...
GitHub

From SQL to SPL：Substring from a column of strings

105009400068600 WNr1.4112 Inox Rund 8.00 mm nach EN 10088-3 + A+C+SL, gesch 105009400068700 WNr1.4301 Inox Rund 36.00 mm nach EN 10088-3, geschliffen, T 105009400068800 WNr1.4104 Inox Rund 25.00 mm ...
cloud

Getting AI to write good SQL: Text-to-SQL techniques explained

Organizations depend on fast and accurate data-driven insights to make decisions, and SQL is at the core of how they access that data. With Gemini, Google can generate SQL directly from natural ...
Hacker

How to Master SQL Joins - Inner, Outer, Cross, and Self-Joins With Examples

Hello there! 👋 I'm Jin, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI SQL joins are a fundamental feature for combining data from multiple tables based on ...
bilibili

鲸析SQL刷题挑战 DAY 5：substring细节

SUBSTRING(str, start [, length]) str：表示要进行提取操作的原始字符串。 start：指定开始提取的位置。位置从 1 开始计数，如果 start 为正数，则从字符串的开头开始计数；如果 start 为负数，则从 ...
Hacker

SQL Window Functions: A Quick Review With Examples

Thank you for taking the time to explore data-related insights with me. I appreciate your engagement. If you find this information helpful, I invite you to follow me or connect with me on LinkedIn.