How the query works when meets functions?

Thanks,I would like to know the execution order of the query. As you know, the order in which sql database (mysql as example) execution the different functions such as select,where,join …etc is different. The different order of the functions may lead to different results.