PHP MYSQL Query Array Field

Question

Ok. I'm using MySQL and PHP. I have a table called "Pictures" and a field in that table called "Tagged." This field is an array of UserIds which I imploded and stored as a string.

example: 114,159,14,334

Lets say I want to return all the rows in "Pictures" where a particular UserID, say 14, exists somewhere in the "Tagged" field's array. How can this be done?

You're headed down a bad path. Normalize the schema first. Add a UserPictureTag table. — dkretz
– dkretz, Commented Jan 17, 2011 at 5:56
do you have any links or suggestions as to a better approach? The pictures table is pretty small right now, but I can see how this approach might slow things down on a larger scale. — rollsRLS8822
– rollsRLS8822, Commented Jan 17, 2011 at 6:38

Shakti Singh · Accepted Answer · 2011-01-17 06:24:34Z

4

select * from pictures where FIND_IN_SET(14,Tagged);

edited Jan 17, 2011 at 6:24

answered Jan 17, 2011 at 5:38

Shakti Singh

86.7k21 gold badges140 silver badges155 bronze badges

this query isn't returning any results.

rollsRLS8822
– rollsRLS8822

01/17/2011 06:16:00
Commented Jan 17, 2011 at 6:16
@rollsRLS8822:Pass the id as a first argument and column name as a second argument will work check updated one.

Shakti Singh
– Shakti Singh

01/17/2011 06:25:52
Commented Jan 17, 2011 at 6:25

Add a comment |

John M. · Accepted Answer · 2011-01-17 05:40:17Z

0

Start it with a , and end with a , like this: ,114,159,14,334, and then do a SELECT FROM Pictures WHERE tagged='%,14,%'

Just an idea, I really don't know... I've never done this before. Traditional blog tagging may be similar enough that you could look up some tutorials to learn from them.

answered Jan 17, 2011 at 5:40

John M.

2,2734 gold badges24 silver badges39 bronze badges

Add a comment |

Collectives™ on Stack Overflow

PHP MYSQL Query Array Field

2 Answers 2

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related