Free download mysql string fuctions...

by barkkathulla 2012-09-22 12:09:06


SELECT ASCII('F')
RETURNS ASCII CODE OF CHARACTER

SELECT CHAR(70)
RETURNS THE CHARACTER EQUIVALENT OF THE ASCII CODE.

SELECT CHARINDEX('K','ARUN KUMAR')
RETURNS THE STRING POSSITION OF THE SPECIFIED PATTER.

SELECT LOWER("ENGLISH")
CONVERT TO LOWERCASE

SELECT UPPER("ENGLISH")
CONVERT TO UPPERCASE


SELECT LTRIM(" ENGLISH")
RETURNS DATA WITHOUT LEADING BLANKS

SELECT RTRIM("ENGLISH ")
RETURNS DATA WITHOUT TRAILING BLANKS


SELECT REVERSE("ENGLISH")
RETURNS THE REVERSE OF GIVEN STRING

SELECT REPLICATE("ENGLISH",3)
REPEATS THE CHARACTER EXPRESSION A SPECIFIED NUMBER OF TIMES.


SELECT LEFT("ENGLISH",3)
RETURNS PART OF A CHARACTER STRING STARTING INTEGER_EXPR CHARACTER FROM THE LEFT.

SELECT RIGHT("ENGLISH",3)
RETURNS PART OF A CHARACTER STRING STARTING INTEGER_EXPR CHARACTER FROM THE RIGHT.

SELECT REPLACE("ENGLISH","G","K")
REPLACES ALL OCCURRENCES OF THE SECOND GIVEN STRING EXPRESSION IN THE FIRST STRING EXPRESSION WITH A THIRD EXPRESSION.

SELECT LEN("ENGLISH")
RETURNS THE LENGTH OF CHARACTER EXPRESSION.

SELECT SUBSTRING("ENGLISH",4,3)
RETURNS PART OF A CHARACTER EXPRESSION.

SELECT SPACE(20)
RETURNS A STRING OF REPEATED SPACE.
632
like
0
dislike
0
mail
flag

You must LOGIN to add comments