MySQL Functions Reference

How many times have you sat at your desk trying to remember that MySQL function you need in your code ? even worse you know the name of the function but can’t get it to work.

Simple functions such as CEILING or ROUND tend to stick in your mind, but what about STR_TO_DATE or REGEXP, these functions are in some circumstances vital to your work but what if you can’t remember them or need an example of its syntax ?

Our MySQL Reference app lists all available functions, gives a concise explanation of each and at least one example of its usage, each accompanied with the output of the select statement.

The functions are listed alphabetically, but a pull down drawer splits the functions into their specific usage, therefore they are sub-grouped into the following key areas …

Number
String
Date
Aggregate
Regex
Misc

In addition we have added sections which our own Developers have identified as useful aids to the memory, therefore we break down the lists of Date formats, list all the types of Where clauses and Regex usage etc … all very useful when writing MySQL

We offer two versions of this app, one free with adverts the other a paid version without adverts, both are the same, both work on Phones, and all sizes of Tablets, we hope you will find them useful, we do.