php select number in string

Question

I have query like this

SELECT * FROM table WHERE id ='1'

but in column id store data like this

array (size=2)
   0 => string '1' (length=1)
   'id' => string '1' (length=1)
array (size=2)
   0 => string '1,2' (length=3)
   'id' => string '1,2' (length=3)
array (size=2)
   0 => string '1,2,3' (length=5)
  'id' => string '1,2,3'

Result of my query is show only 1 row but what I need is show every row that has value 1 in it.

plz help me with it

possible duplicate of mysql check if numbers are in a comma separated list — Kanishka Panamaldeniya
– Kanishka Panamaldeniya, Commented Oct 19, 2014 at 17:11

Fabio · Accepted Answer · 2014-10-19 17:02:43Z

1

I think you can use LIKE %% to achieve this

SELECT * FROM table WHERE id LIKE '%1%'

answered Oct 19, 2014 at 17:02

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

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

1 Comment

koe Over a year ago

I need real value not probably value

Daryl Gill · Accepted Answer · 2014-10-19 17:17:04Z

0

Pull from the table as the current data, then:

 $NewArr = array();
 foreach ($Array as $values){
      $NewArr[] = (int) @values;

 }

answered Oct 19, 2014 at 17:17

Daryl Gill

5,52511 gold badges41 silver badges71 bronze badges

Collectives™ on Stack Overflow

php select number in string

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related