Tag: mysql

Mapping series – an aside, a note on views in MySQL

16 – 02 – 20

While working on a project recently – a mapping one which required complex queries – I worked more […]
Mapping series – MySQL queries against latitude and longitude

15 – 02 – 20

I’m starting this series with the simplest aspect – a MySQL query to return rows based on radius […]
Selecting title, meta and multiple term names with MySQL

11 – 01 – 18

I often run one off reports for clients directly from the MySQL database behind their (normally WordPress) websites. […]
Ignore spaces when group MySQL query results

27 – 11 – 17

Let's get a list of all duplicate postcodes (could be any string of course) out of a specific […]
Reverse relationship query for last ACF repeater sub-field

11 – 07 – 17

Advanced Custom Fields (ACF) is a great WordPress plugin for adding custom meta fields. It has a very […]

Mapping series – an aside, a note on views in MySQL