Re: slightly OT: need an unusual find condition (or possible custom query)

2009-01-28 Thread Martin Westin
Thanks AD, I did have an nagging suspicion that this would require something like that with temporary tables and things. What I did for now (until I do some performance testing on it and in case anyone find it useful) was: 1. A deleteAll using a "NOT" condition. Deletes anything that does not mat

Re: slightly OT: need an unusual find condition (or possible custom query)

2009-01-26 Thread AD7six
On Jan 26, 2:35 pm, Martin Westin wrote: > Hi, > I am in need of an unusual query that I find it hard to search for on > Google or MySQL.com since all the terms I think of are very common > ones. Hopefully someone reading this can guide me in the right > direction. > > I have a series of values

Re: slightly OT: need an unusual find condition (or possible custom query)

2009-01-26 Thread brian
I think you'll need to loop through the array with find('count'). On Mon, Jan 26, 2009 at 8:35 AM, Martin Westin wrote: > > Hi, > I am in need of an unusual query that I find it hard to search for on > Google or MySQL.com since all the terms I think of are very common > ones. Hopefully someone r

slightly OT: need an unusual find condition (or possible custom query)

2009-01-26 Thread Martin Westin
Hi, I am in need of an unusual query that I find it hard to search for on Google or MySQL.com since all the terms I think of are very common ones. Hopefully someone reading this can guide me in the right direction. I have a series of values in an array. I can find out which records have matching