STRING FUNCTIONS IN MYSQL

Hi..welcome to my blog at “We Are Knowledge”. Do you seek knowledge of MYSQL? You are choice the right blog.. Let’s do read this artice.. Than you will getting it..

Still with program language MYSQL, but different subject matter. Now I want giving you knowledge about “function in MYSQL”.. But in article I just giving you “String function on MYSQL”.

Ok … direct to go…

1. String functions

MYSQL programming languages ​​there are also string functions that we can use to simplify our work. And string functions in MySQL is ::

A. Concat

As well as other programming languages​​, this function is used to combine two (2) pieces or more strings

B. Substr

The function of this one to take as much of the string 'n' characters

C. Legth

Views of the meaning of the term, it means the function is used to count the number of characters in a string

D. Left and Right

Left is used to retrieve a string from the left as 'n' characters

Right is used to retrieve a string from the right as 'n' characters

E. Ltrim, Rtrim, Trim

Ltrim used to remove spaces at the beginning of the string

Rtrim used to remove spaces at the end of the string

Trim is a combination of ltrim and rtrim, and is used to remove spaces at the beginning and end of the string

F. Replace

If you want to replace a string with another string, you can use this string function

G. Repeat

The following string functions to copy the string that we have as much 'n' strings

H. Reverse

For the following function is used when we want to reverse the string. eg: MYSQL to LQSYM

I. Lower And Upper

To function 'Lower' is useful to convert the string to lower case all

To function 'Upper' useful to convert a string into all lowercase

Ok.. just it…

I hope you understand..

See you later.