As a general rule, is it better to perform data functions, such as "substr" in a database query, or in a app such as PHP?
Do all static queries in the DBMS application. If it is dynamic aka user input determines query, do it with php.
If it is a static queries i would write it by hand, so i guess PHP is the best way to go
