MySQL String Functions

SQL Cheatsheet Description

Various MySQL SQL functions for working with charactor data.

Cheatsheet

Description Function
Compare strings

strcmp(string1,string2)

Convert to lower case

lower(string)

Convert to upper case

upper(string)

Left-trim whitespace (similar right)

ltrim(string)

Substring of string

substring(string,index1,index2)

Encrypt password

password(string)

Encode string

encode(string,key)

Decode string

decode(string,key)

 Collapse All    Expand All
Custom Search

MySQL Information and Resources