STARTS_WITH

starts_with

description

Syntax

BOOLEAN STARTS_WITH(VARCHAR str, VARCHAR prefix)

如果字符串以指定前缀开头，返回true。否则，返回false。任意参数为NULL，返回NULL。

example

MySQL [(none)]> select starts_with("hello world","hello");
+-------------------------------------+
| starts_with('hello world', 'hello') |
+-------------------------------------+
|                                   1 |
+-------------------------------------+

MySQL [(none)]> select starts_with("hello world","world");
+-------------------------------------+
| starts_with('hello world', 'world') |
+-------------------------------------+
|                                   0 |
+-------------------------------------+

keywords

STARTS_WITH