Skip to content

STARTSWITH()

Description

Returns 1 whether string starts with the specified prefix, otherwise it returns 0.This function is case sensitive.

Syntax

> STARTSWITH(str,prefix)

Arguments

Arguments Description
str Required. CHAR and VARCHAR both are supported.
prefix Required. CHAR and VARCHAR both are supported.

Returned Values

  • 1, if the string starts with the specified prefix.
  • 0, if the string does not start with the specified prefix.

Examples

> drop table if exists t1;
> create table t1(a int,b varchar(100),c char(20));
> insert into t1 values
(1,'Ananya Majumdar', 'IX'),
(2,'Anushka Samanta', 'X'),
(3,'Aniket Sharma', 'XI'),
(4,'Anik Das', 'X'),
(5,'Riya Jain', 'IX'),
(6,'Tapan Samanta', 'X');
> select a,startswith(b,'An') from t1;
+------+-------------------+
| a    | startswith(b, An) |
+------+-------------------+
|    1 |                 1 |
|    2 |                 1 |
|    3 |                 1 |
|    4 |                 1 |
|    5 |                 0 |
|    6 |                 0 |
+------+-------------------+
> select a,b,c from t1 where startswith(b,'An')=1 and startswith(c,'I')=1;
+------+-----------------+------+
| a    | b               | c    |
+------+-----------------+------+
|    1 | Ananya Majumdar | IX   |
+------+-----------------+------+

Constraints

Currently, MatrixOne doesn't support select function() without from tables.