harry

Find the some basic mysql String Functions which we can use in our queries for better performance and efficiency

1) CONCAT() Return concatenated string

2) FIELD() Return the index (position) of the first argument in the subsequent arguments.
3) LTRIM() Remove leading spaces
4) RIGHT() Return the specified rightmost number of characters.
5) RTRIM() Remove trailing spaces.
6) SUBSTRING() Return the substring as specified.
7) UPPER() Convert to uppercase.
8) LENGTH(str) for check the length of string.
9) LPAD() Return the string argument, left-padded with the specified string
10) SPACE() Return a string of the specified number of spaces.

sharma.s.prakash

thanks for sharing

harry

thanks satttttttttttttttttttttu