A brief analysis of Mysql's string function _mysql

1. Left function to intercept the string contents of the query field, using the Select Left (content,50) as summary from article; The meaning here is to query only the first 50 characters of the content column, where the Chinese character is used only as a single character.

2. Right function, in contrast to the left function, intercepts the content from the back.

3. The upper function, which capitalizes the lowercase letters in the contents of the query. Select Upper (title) as title from article;

4. Lower function, and upper just the opposite, it is lowercase processing.

5. The SUBSTR function, which cuts the specified length from the specified position, is more flexible than left and right. Select substr from article to intercept 50 characters from the 10th character (the first character 1 is not 0), select substr (content,10) from article, and the 10th Word Character begins to intercept to the end, select substr (content,–20) from article, and 20 characters from the end.