Codeigniter Mysql column with comma seperated values

Question

I wnat to test a field with multiple values against single value, my SQL is like .

WHERE id (1);

Database values are like

id
---
1,2

2,3

1,3,4

codeigniter

$this->db->select('*');
$this->db->from('content');
$this->db->where('name', $name);
$this->db->where('id', $id);

I tried

$this->db->where_in('id', explode(',', $id));

but its not working.Please help me to solve this.

where_in is working if the id value(eg.(1,2)) and database value(1,2) are same.If id value is 1 and database value is(1,2) its not working.@ Kaleem — Dingo Ghatr
– Dingo Ghatr, Commented Mar 14, 2018 at 5:52
Then like() is not good option for you. It will get records having 2,12,22,32 ...222 and so on when you will search with id=2. Please look at this option. Looks good for your problem — Kaleem
– Kaleem, Commented Mar 14, 2018 at 6:04

M Khalid Junaid · Accepted Answer · 2018-03-14 05:50:57Z

6

To find the values from a given set you can use FIND_IN_SET

$this->db->where("FIND_IN_SET(".$id.",id) >", 0);

Note: This type of design is considered as a bad design and you should normalize your structure, I suggest you to have a look at Database Normalization

answered Mar 14, 2018 at 5:50

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Abdulla Nilam · Accepted Answer · 2018-03-14 05:46:15Z

2

What if you use like() instead of where()

$this->db->like('id', $id);
// Produces: WHERE `id` LIKE '%2%' ESCAPE '!'

Note: If 2 is the value 2,22,222 will pass through this

answered Mar 14, 2018 at 5:46

Abdulla Nilam

39.6k18 gold badges85 silver badges115 bronze badges

Comments

Gufran Hasan · Accepted Answer · 2018-04-12 03:10:09Z

0

Please try this one:

$this->db->select('*')->from('table_name')
       ->where("column_name LIKE '%$key_values%'")->get();

answered Apr 12, 2018 at 3:10

Gufran Hasan

9,4297 gold badges44 silver badges57 bronze badges

Collectives™ on Stack Overflow

Codeigniter Mysql column with comma seperated values

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related