get string

putraaridana

hi
i have field in mysql table like this
field 1=001002003 type string
i want to get the i want to get data=002 only,
mayby some expert can help me
thanks

TheDefender

Can you consider changing the way you store the data, so that they are separated by a delimiter?

Something like:
field1=001|002|003|004

That way, you can explode() the data in the field and do a search on the resulting array... It's quicker and easier like this, especially if the data changes to something else:
field1=032|596|050|002

LordShryku

That sort of delimiting defeats the purpose of using a relational database though...

putraaridana

thanks
that's really work

TheDefender

LordShryku... I agree that it's always best to normalise the tables before storing data like this, but I don't even know what the data represents, it's uniqueness, etc...

LordShryku

Just thought I'd put it out there. Felt obligated...

TheDefender

Yeah, don't get me wrong. Like I said, I agree. I try not to answer more than what's being asked if I can help it... Usually leads to the never ending thread, because more q's get raised. Plus, you then obligate yourself to be the personal tech... I know it isn't fair to brand everyone that way... That comes from my Tech Support background 😉

LordShryku

Sure, but if I see someone doing something blatantly wrong, I'll point it out. It's better to have the never-ending thread, with that person getting a sense of how to do something right, then it is to answer the specific question and let them continue doing it wrong and thinking it 's right.

TheDefender

I concede your point. :glare:

LordShryku

w00t!!!!
/me pounds another one into submission!

😃

TheDefender

...Until we meet again... <<< galloping off into the distance >>>