I have multiple values in branch_id with comma how can

Question

PHP

Pirate

I have multiple values in branch_id with comma how can

I check a value is in the branch_id or not ?

0

05.11.2021

5 ответов

10 просмотров

palone

That looks like two values...

0

05.11.2021

Guido Vera

this is not ideal and it really looks like crazy technical debt 😂 either way, if your table is not crazy big you can do a select with a like '%{branch_id}%'. If it is crazy big I'd recommend you to use an index there so your select is fast.

0

05.11.2021

oyepez003️ ️

Guido Vera
this is not ideal and it really looks like crazy t...

That will not work because like %{branch_id}% is going to return all the lines that matches with any branch_id, for example like '%1%' returns any rows that contains this branch id "1","10","111","10001","21","31" etc...

0

05.11.2021

Guido Vera

oyepez003️ ️
That will not work because like %{branch_id}% is g...

right 😂

0

05.11.2021

Bryan · Accepted Answer

Bryan

Am curious. Why did you decide to design your database this way ?

0

05.11.2021

Похожие чаты

I have multiple values in branch_id with comma how can

5 ответов

Похожие вопросы