Re: [PHP] search in serialized string

2002-08-27 Thread DL Neil
Rodrigo, Yuk! No wonder I was having trouble visualising your problem... The serialised field cannot be meaningfully indexed (it's a waste of time if it is). That means that any search against a criteria involving a/the serialised field will require (the time to perform an) the examination of eve

Re: [PHP] search in serialized string

2002-08-26 Thread Rodrigo Peres
I mean double ouch!!! :-) well.. 1 no, it's a select for the language ( Rodrigo, > > Inherited problems = ouch! > > Sorry I don't keep old list msgs, perhaps you mentioned this before: does > the language skills field contain: > 1 both the language and the skill-level, eg English - Advanced >

Re: [PHP] search in serialized string

2002-08-26 Thread DL Neil
Rodrigo, Inherited problems = ouch! Sorry I don't keep old list msgs, perhaps you mentioned this before: does the language skills field contain: 1 both the language and the skill-level, eg English - Advanced 1b what separator is used between the two words? 2 more than one language/skill-level wh

Re: [PHP] search in serialized string

2002-08-26 Thread Rodrigo Peres
well, I my opinion is not the way to work, but like I said the work was done by other guy, and now I have the problem to solve. So i back to old question :-) How can I search with some precision in a serialized string? on 8/24/02 12:13 PM, DL Neil at [EMAIL PROTECTED] wrote: > Rodrigo, > > Th

[PHP] search in serialized string

2002-08-22 Thread Rodrigo Peres
Hi list, I have a form to post resumes. In one parte the user have a option to choose up to 5 languages and his knowledge in it. example : english: basic advanced My problem is that was stored serialized in the BD and now I need to do a search by language and knowledge. How can I do this. I

[PHP] search in serialized string

2002-08-21 Thread Rodrigo Peres
Hi list, I have a form to post resumes. In one parte the user have a option to choose up to 5 languages and his knowledge in it. example : english: basic advanced My problem is that was stored serialized in the BD and now I need to do a search by language and knowledge. How can I do this. I