Get value from a table where field value has stored separated by comma using codeigniter

Question

This is my communication_posting table

Into fields 2,3 are user_id in user_master table. This is my user_master table (used for login ).

I want to get session_id means store in to column in communication_posing table but here two session_id (mean user_id) has store how to get only one from them.

SELECT content FROM t_communication_posting WHERE FIND_IN_SET(2,to) — dipti, Jul 14 '17 at 11:32

score 0 · Answer 1 · answered Jul 14 '17 at 13:53

If you are doing this in two seperate queries, you can use php explode().

$explode_array = explode(',', $database_result['to']);
$value_you_want = $explode_array[0];

If you need to do this in SQL, create a split function in MySQL. This question has some answers that will help.

Can you split/explode a field in a MySQL query?

Get value from a table where field value has stored separated by comma using codeigniter

1 Answers1