Home Database Mysql Tutorial SQL Server四种匹配符的含义

SQL Server四种匹配符的含义

Jun 07, 2016 pm 04:17 PM
server match meaning

四种匹配符的含义 % 代表零个或者多个任意字符 代表一个任意字符 [] 指定范围内的任意单个字符 [^] 不在指定范围内的任意单个字符 带有匹配符的字符串必须使用引号引起来,例如下面的示例: LIKE 'BR%'返回以BR开始的任意字符串。 LIKE 'Br%'返回以Br开始的

四种匹配符的含义 % 代表零个或者多个任意字符 代表一个任意字符 [] 指定范围内的任意单个字符 [^] 不在指定范围内的任意单个字符 带有匹配符的字符串必须使用引号引起来,例如下面的示例: LIKE 'BR%'返回以“BR”开始的任意字符串。 LIKE 'Br%'返回以“Br”开始的任意字符中。 LIKE '%een'返回以“een”结束的任意字符串。 LIKE '%en%'返回包含“en”的任意字符串。 liKE 'en'返回以“en”结束的三个字符的字符串。 LIKE '[CK]%'返回以“C”或者“K”开始的任意字符串。 LIKE '[S-V]lng'返回长为四个字符的字符串,结尾是“ing”,开始是从S到V LIKE 'M[^c]%'返回以“M”开始且第二个字符不是“c”的任意字符串。  注意: 使用LIKE运算符通常会导致SQL Server不对给定的表使用与之联系的索引。它告诉SQL server比较所指定的字符串并且找到与所提供的匹配符相匹配的任何内容。由于这种原固,,不推荐在大型表上使用这种类型的搜索或者比较,至少应该提醒用户,系统寻找满足搜索标准的数据行时所需的等待时间非常重要。
--------------------------------------------------------------------------------
 

 

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

What is WICC Coin? What is WICC Coin? Feb 21, 2024 pm 06:00 PM

What is WICC Coin? WICC Coin is the abbreviation of WaykiChainCoin, which is a digital currency based on blockchain technology. As an efficient, scalable and secure public chain, WaykiChain is committed to providing enterprises and developers with complete blockchain infrastructure and innovative tools. As the core token of the WaykiChain ecosystem, WICC Coin plays an important role on the platform. Features of WICC currency 1. Safe and reliable: WaykiChain adopts the DPoS consensus algorithm and has a reliable distributed locking mechanism and consensus mechanism to ensure a high degree of network security. 2. Efficient and scalable: WaykiChain has millisecond-level transaction confirmation speeds, can handle thousands of transactions per second, and

Practical Guide to Regular Expressions in Go: How to Match Hexadecimal Color Codes Practical Guide to Regular Expressions in Go: How to Match Hexadecimal Color Codes Jul 13, 2023 am 10:46 AM

Go Language Regular Expressions Practical Guide: How to Match Hexadecimal Color Codes Introduction: Regular expressions are a powerful and flexible tool for pattern matching and finding strings. In Go language, we can use the built-in regular expression package regexp to implement these operations. This article will introduce how to use regular expressions to match hexadecimal color codes in Go language. Importing the regular expression package First, we need to import the regular expression package regexp of the Go language. You can add the following import statement at the beginning of the code: i

How to install, uninstall, and reset Windows server backup How to install, uninstall, and reset Windows server backup Mar 06, 2024 am 10:37 AM

WindowsServerBackup is a function that comes with the WindowsServer operating system, designed to help users protect important data and system configurations, and provide complete backup and recovery solutions for small, medium and enterprise-level enterprises. Only users running Server2022 and higher can use this feature. In this article, we will explain how to install, uninstall or reset WindowsServerBackup. How to Reset Windows Server Backup If you are experiencing problems with your server backup, the backup is taking too long, or you are unable to access stored files, then you may consider resetting your Windows Server backup settings. To reset Windows

Understand the meaning of eol in PHP Understand the meaning of eol in PHP Mar 20, 2024 am 11:09 AM

In-depth understanding of the meaning and code examples of eol in PHP In PHP programming, eol is a common term that represents "EndOfLine", which is the end of the line. In different operating systems, the end of a line may be expressed differently, which leads to the concept of eol. In Windows systems, the end of a line is composed of carriage return () and line feed (), that is, ""; while in Unix/Linux systems, the end of a line is only represented by line feed (), that is, "". Such differences may result in different operating systems

How to turn off the content display function of Kuaishou private messages? What does it mean to turn off the display content of Kuaishou private messages? How to turn off the content display function of Kuaishou private messages? What does it mean to turn off the display content of Kuaishou private messages? Mar 21, 2024 pm 05:41 PM

As the leading short video platform in China, Kuaishou has a large number of users, and the private messaging function is an important channel for interaction between users. However, some users may find the ability to display content in private messages bothering them and would like to be able to selectively turn this feature off. 1. How to turn off the content display function of Kuaishou private messages? 1. Open the Kuaishou app and log in to your personal account. 2. Enter the Kuaishou main interface and click the "My" button in the lower right corner to enter the personal center. 3. On the personal center page, click the avatar to enter personal settings. 4. On the personal settings page, find the "Privacy Settings" option and click to enter. 5. On the privacy settings page, find the "Display content in private messages" option and click to enter. 6. On the private message display content setting page, turn off the "private message display content" function

PHP regular expression in action: matching letters and numbers PHP regular expression in action: matching letters and numbers Jun 22, 2023 pm 04:49 PM

PHP regular expression practice: matching letters and numbers Regular expression is a tool used to match strings, which can easily realize string search, replacement, split and other operations. Regular expressions are also a very useful tool in PHP development. This article will introduce how to use PHP regular expressions to match letters and numbers. Matching a Single Character To match a single character, you can use the character classes in regular expressions. Character classes are represented by square brackets []. The characters in them represent the characters that can be matched. You can use hyphens - to represent ranges.

PHP regular expressions: exact matching and exclusion of fuzzy inclusions PHP regular expressions: exact matching and exclusion of fuzzy inclusions Feb 28, 2024 pm 01:03 PM

PHP Regular Expressions: Exact Matching and Exclusion Fuzzy inclusion regular expressions are a powerful text matching tool that can help programmers perform efficient search, replacement and filtering when processing text. In PHP, regular expressions are also widely used in string processing and data matching. This article will focus on how to perform exact matching and exclude fuzzy inclusion operations in PHP, and will illustrate it with specific code examples. Exact match Exact match means matching only strings that meet the exact condition, not any variations or extra words.

Detailed explanation of the meaning of MySQL host name Detailed explanation of the meaning of MySQL host name Mar 01, 2024 pm 12:03 PM

The meaning and specific usage of MySQL host name MySQL is a popular open source relational database management system that is widely used in various web applications. In MySQL, hostname is an important concept, which is used to specify the name of the host connected to the database server. In this article, we will explain in detail what the MySQL hostname means and how to use it in actual development. The meaning of MySQL host name: In MySQL, the host name is used to specify which connections are allowed to

See all articles