Simple Mysql query
Budget: £10 – £20 GBP
This is a very simple project, in reality, a question.
I have a table called table1
# user_id, email, identifier, value
'1, 'myemail@email..com', 'firstName', 'john'
'1', 'myemail@email..com, 'lastName', 'doe'
'2', 'myemail2@email..com', 'firstName', 'Bob'
'2', 'myemail2@email..com', 'lastName', 'Builder'
I need help from a Mysql expert to return the results on a single row as:
user_id, email, first_name, last_name
So it needs to extract the fields from firstName.value and lastName.value into new columns.
I have a table called table1
# user_id, email, identifier, value
'1, 'myemail@email..com', 'firstName', 'john'
'1', 'myemail@email..com, 'lastName', 'doe'
'2', 'myemail2@email..com', 'firstName', 'Bob'
'2', 'myemail2@email..com', 'lastName', 'Builder'
I need help from a Mysql expert to return the results on a single row as:
user_id, email, first_name, last_name
So it needs to extract the fields from firstName.value and lastName.value into new columns.