Re: SELECT statement with multiple WHERE conditions

[Rick James]

SELECT FieldValue WHERE (FieldName = "username") (WHERE (FieldName = "email") AND (FieldValue = " $user->email"))

SELECT m.*,
a1.value AS UserName,
a2.value AS EMail
...
FROM main_table m.id
JOIN attributes a1 ON a1.entity_id = m.id AND a1.fieldname = 'username'
JOIN attributes a2 ON a2.entity_id = m.id AND a2.fieldname = 'email'
...
WHERE ...

Or...

SELECT m.*,
( SELECT value FROM attributes WHERE entity_id = m.id AND fieldname = 'username' ) AS UserName,
( SELECT value FROM attributes WHERE entity_id = m.id AND fieldname = 'email' ) AS Email,
FROM main_table m.id
WHERE ...