---
title: AVG, MAX, MIN on meta_value in WordPress
date: 2013-02-17T10:23:57+00:00
modified: 2013-02-18T08:32:40+00:00
permalink: https://kaspars.net/blog/avg-max-min-meta-value
post_type: post
author:
  name: Kaspars
  avatar: https://reverse.kaspars.net/gravatar/avatar/92bfcd3a8c3a21a033a6484d32c25a40b113ec6891f674336081513d5c98ef76?s=96&d=mm&r=g
category:
  - Development
  - WordPress
post_tag:
  - MySQL
  - Snippet
---

# AVG, MAX, MIN on meta\_value in WordPress

If you want to do MAX, MIN, AVG or other kind of mathematical operation on non-numeric MySQL columns (such as longtext for `meta_value` in WordPress), you can cast it to float like this:

```
SELECT 
	meta_key, 
	MAX(meta_value+0.0) max_meta 
FROM 
	postmeta 
WHERE 
	meta_key='your_key' 
GROUP BY 
	meta_key
```