Hi Devs
I have a tricky question and I want to know if its possible to accomplish it
on mysql and how.
The following query:
SELECT
fields.id AS field_id,
data.user_id,
fields.type,
fields.name,
data.value,
entries.ip,
entries.date,
entries.user_agent
FROM
I think I acompplish it!
Merge that query into a view called report_1 and then:
(1) SELECT user_id, MAX(IF(name='RUT',value,NULL)) AS 'Rut',
MAX(IF(name='Name',value,NULL)) AS 'Name' FROM report_1 GROUP BY user_id;
+-+---++
| user_id | Rut | Name |