[Day15] SQL server like用法 - SQL Server資料庫入門

在這回中將探討SQL server中like的使用方式。

like被用在SQL語法中的where條件。
用來篩選模糊字串。

通常搭配這兩種運算子去實作模糊搜尋條件。

% 代表零或一個或更多的字符
_ 代表一個字符

語法:

1
2
3

SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern;

常見的模糊字串操作:

LIKE Operator	Description
WHERE CustomerName LIKE 'a%'	Finds any values that start with "a"
WHERE CustomerName LIKE '%a'	Finds any values that end with "a"
WHERE CustomerName LIKE '%or%'	Finds any values that have "or" in any position
WHERE CustomerName LIKE '_r%'	Finds any values that have "r" in the second position
WHERE CustomerName LIKE 'a_%'	Finds any values that start with "a" and are at least 2 characters in length
WHERE CustomerName LIKE 'a__%'	Finds any values that start with "a" and are at least 3 characters in length
WHERE ContactName LIKE 'a%o'	Finds any values that start with "a" and ends with "o"