group concat - Using mysql in to display only values present in register using group_concat() -

group concat - Using mysql in to display only values present in register using group_concat() -

i have 2 tables incoming_sms , subscribers_register stores of numbers of customers.the table incoming_sms has lots of info many numbers want select messages subscribers.

i have query trying utilize show messages subscribers returns 0 results

select dest_msisdn, text_message incoming_sms dest_msisdn in (select group_concat(msisdn) subscribers_register);

why getting 0 results?.

have @ help group_concat. it's going homecoming long string of msisdn's instead of list of msisdn's.

you this:

select dest_msisdn, text_message incoming_sms dest_msisdn in (select msisdn subscribers_register)

... or may find inner bring together faster execute:

select dest_msisdn, text_message incoming_sms inner bring together subscribers_register on incoming_sms.dest_msisdn = subscribers_register.msisdn

mysql group-concat