rgb192
asked on
how did you hear about us?
I think this question may be related to
https://www.experts-exchange.com/questions/28280747/indicate-row-or-profile-id-which-needs-to-be-responded-to.html
I want either the field (profile_id) or the row of the answer.
Real world explanation:
find customers the who messaged us first
Ask them questions such as 'how did you hear about us: radio, tv, internet, friend'
Because these customers did not hear about us from us, because they sent us the first message.
select profile_id, sender,message_id,this_use r from a_messages2 where profile_id='abl' order by message_id limit 1
select profile_id, sender,message_id,this_use r from a_messages2 where profile_id='swa' order by message_id limit 1
staff3 sent first message to swa '4142884976'
abl sent first message to staff3 '3609276896'
there should be results for abl because abl sent first message
but there should be no results for swa, because we sent the first message
https://www.experts-exchange.com/questions/28280747/indicate-row-or-profile-id-which-needs-to-be-responded-to.html
I want either the field (profile_id) or the row of the answer.
CREATE TABLE `a_messages2` (
`a_messages_id` INT (11) auto_increment primary key
, `profile_id` VARCHAR(20)
, `sender` VARCHAR(20)
, `message_id` BIGINT (20)
, `this_user` VARCHAR(20)
);
INSERT INTO a_messages2
(`profile_id`, `sender`, `message_id`, `this_user`)
VALUES
('abl', 'staff3', 3662615602, 'staff3'),
('abl', 'abl', 3660687080, 'staff3'),
('abl', 'staff3', 3658803944, 'staff3'),
('abl', 'staff3', 3649952930, 'staff3'),
('abl', 'staff3', 3644250249, 'staff3'),
('abl', 'staff3', 3614235515, 'staff3'),
('abl', 'abl', 3614140442, 'staff3'),
('abl', 'staff3', 3613984751, 'staff3'),
('abl', 'staff3', 3613936332, 'staff3'),
('abl', 'abl', 3613469574, 'staff3'),
('abl', 'staff3', 3612970481, 'staff3'),
('abl', 'abl', 3609276901, 'staff3'),
('abl', 'abl', 3609276896, 'staff3'),
('abl', 'staff3', 3866086756, 'staff3'),
('abl', 'staff3', 3866079064, 'staff3'),
('abl', 'abl', 3856964132, 'staff3'),
('abl', 'staff3', 3844779912, 'staff3'),
('abl', 'staff3', 3916948647, 'staff3'),
('abl', 'staff3', 3880367425, 'staff3'),
('abl', 'abl', 3977088222, 'staff3'),
('abl', 'staff3', 3974513295, 'staff3'),
('abl', 'staff3', 3973285282, 'staff3'),
('abl', 'abl', 3960907806, 'staff3'),
('abl', 'staff3', 4003664468, 'staff3'),
('abl', 'abl', 4002246444, 'staff3'),
('abl', 'staff3', 3996089944, 'staff3'),
('abl', 'staff3', 4024726432, 'staff3'),
('abl', 'abl', 4021516823, 'staff3'),
('abl', 'staff3', 4018957318, 'staff3'),
('abl', 'abl', 4050609080, 'staff3'),
('abl', 'staff3', 4052368867, 'staff3'),
('abl', 'abl', 4052424820, 'staff3'),
('abl', 'staff3', 4053183569, 'staff3'),
('swa','swa','4153199171','staff3'),
('swa','staff3','4150323049','staff3'),
('swa','swa','4146362776','staff3'),
('swa','staff3','4142884979','staff3'),
('swa','staff3','4142884976','staff3')
Real world explanation:
find customers the who messaged us first
Ask them questions such as 'how did you hear about us: radio, tv, internet, friend'
Because these customers did not hear about us from us, because they sent us the first message.
select profile_id, sender,message_id,this_use
select profile_id, sender,message_id,this_use
staff3 sent first message to swa '4142884976'
abl sent first message to staff3 '3609276896'
there should be results for abl because abl sent first message
but there should be no results for swa, because we sent the first message
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is the new corrected url
https://www.experts-exchange.com/questions/28287736/how-did-you-hear-about-us-more-data.html
https://www.experts-exchange.com/questions/28287736/how-did-you-hear-about-us-more-data.html
ASKER
So I would want to modify this query to show me more information so I can give you more data.