MySQL: Show Databases Like…

Over time our server has grown and we’re now hosting quite a number of client sites, most of which utilise a MySQL database for one reason or another (most often for WordPress).

I’ve got a particular naming standard to keep databases grouped and as I only access our server via the command line this habit of using naming schemes means that I can easily search for those groups of databases using the following MySQL command.


Obviously you’d replace ‘prefix’ with whatever your naming schema dictates!