Database String Functions

Chat_length (s)

Returns the number of characters in the string s

Concat (S1,s2,..)

Combine strings s1,s2 and more into a single string

Cincat_ws (X,s1,s2,....)

Tong Concat (S1,s2,..) function, but the x is added between each string

Insert (S1,X,LEN,S2)

Strong string S2 replaces S1 's x position starting at Len's string

Upper (s), ucaase (s)

All letters of the character Gen S are nominally capitalized

Lower (s), LCase (s)

Turn all the letters of the string s into lowercase letters

Left (S,n)

Returns the first n characters of a string s

Right (S,n)

Returns the second n characters of the string s

LTrim (s)

Remove the space at the beginning of the string s

RTrim (s)

Remove the space at the end of the string s

Trim (s)

Remove the space at the beginning and end of the string s

Repeat (s,n)

Repeats the string s n times

Space (N)

Returns n Spaces

Replace (S,S1,S2)

Strong string S2 refers to the string in string s S1

strcmp (S1,S2)

Compare strings S1 and S2

SUBSTRING (S,n,len)

Gets a string starting from the nth position of the string s in the length Len

Locate (s1,s), position (S1 in s)

Gets the starting position of the S1 from the string s

Reverse (s)

Reverse the order of the string s

Field (S,s1,s2,...)

Returns the first string position that matches the string s

Database String Functions