MySQL query with value

Question

i have 2 table like 1.post

Id  Title        Date
1   Shaghayegh   2015 
2   Adama        2014 
3   roulett      2013

2.postmeta

id  Post_id   Meta_key  Meta_value  
1     1         app         1
2     1         rec      url-rec1
3     1        Square    url-sq1
4     2         app         0
5     2         rec        NULL
6     2        Square      NuLL
7     3         app         1
8     3         rec      url-rec2
9     3        Square     url-sq2

I need a result with mysql query something like this on where app=1

Post.id Post.Title   App      rec       Square
  1      Shaghayegh   1     url-rec1    url-sq1
  3       roulett     1     url-rec2    url-sq2

Is there a way to do that ?

I'm struggling to understand what you're trying to achieve here. What do the 'App', 'rec' and 'Square' represent? They're not columns in your DB so I'm assuming you want to count records with them? — MKC
– MKC, Commented Jul 5, 2015 at 12:35
actually i need a result where app is '1' when app was 1 i need all meta_key and meta_value for that post — Erfan pj
– Erfan pj, Commented Jul 5, 2015 at 12:41

Erfan pj · Accepted Answer · 2015-07-05 14:26:27Z

3

i found the solution, just use MAX (CASE WHEN...)

MAX(CASE WHEN (meta.meta_key = 'square') THEN meta.meta_value ELSE NULL END) AS square

answered Jul 5, 2015 at 14:26

Erfan pj

3811 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sqluser · Accepted Answer · 2015-07-07 03:53:52Z

0

You can use MAX (CASE WHEN...) for convert value as a coloumn

edited Jul 7, 2015 at 3:53

sqluser

5,7127 gold badges44 silver badges52 bronze badges

answered Jul 6, 2015 at 12:49

z_re

342 bronze badges

Collectives™ on Stack Overflow

MySQL query with value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest