1、字符串函数ascii(str)
ord(str) conv(n,from_base,to_base) bin(n) oct(n) hex(n) char(n,...) concat(str1,str2,...) length(str) octet_length(str) char_length(str) character_length(str) locate(substr,str) position(substr in str) locate(substr,str,pos) instr(str,substr) lpad(str,len,padstr) rpad(str,len,padstr) left(str,len) right(str,len) substring(str,pos,len) substring(str from pos for len) mid(str,pos,len) substring(str,pos) substring(str from pos) substring_index(str,delim,count) ltrim(str) rtrim(str) trim([[both | leading | trailing] [remstr] from] str) soundex(str) space(n) replace(str,from_str,to_str) repeat(str,count) reverse(str) insert(str,pos,len,newstr) elt(n,str1,str2,str3,...) field(str,str1,str2,str3,...) find_in_set(str,strlist) make_set(bits,str1,str2,...) export_set(bits,on,off,[separator,[number_of_bits]]) lcase(str) lower(str) ucase(str) upper(str) load_file(file_name)