MySQL query results are displayed as percentages

Looking for some information, and then I used the MySQL string processing of two functions concat () and left ()

1, "CONCAT (str1,str2,...)

Returns a string from the argument's link. Returns null if any argument is null. can have more than 2 parameters. A numeric parameter is transformed into an equivalent string form.

Example

Select CONCAT (' My ', ' S ', ' QL ');

-> ' MySQL '

Select CONCAT (' My ', NULL, ' QL ');

-> NULL

Select CONCAT (14.3);

-> ' 14.3 '

】

2, "left" (str,length)

Intercepts a string from the left. Description: Left-Hand (intercepted field, intercept length)

】

Combined 1, 2:concat (left (value 1/value 2 *100,5), '% ') as complaints