Re: [Dbix-class] search any matching word in given string in table column which has only one word

2012-08-11 Thread Rajeev Prasad
thanks a lot that worked! From: Rodrigo To: Rajeev Prasad ; DBIx::Class user and developer list Cc: mysql list Sent: Saturday, August 11, 2012 11:12 AM Subject: Re: [Dbix-class] search any matching word in given string in table column which has only one

Re: search any matching word in given string in table column which has only one word

2012-08-11 Thread Shawn Green
On 8/11/2012 12:05 PM, Rajeev Prasad wrote: here is given string of type:... "as23,rt54,yh79" and i have to lookup in a table which has column "id" which has only one four letter word. i have to select that row in which the colum 'id' value matches any of the word in given string... ... snipp

search any matching word in given string in table column which has only one word

2012-08-11 Thread Rajeev Prasad
here is given string of type:...   "as23,rt54,yh79" and i have to lookup in a table which has column "id" which has only one four letter word. i have to select that row in which the colum 'id' value matches any of the word in given string... table column: id contents like: | id| |sd32| |wa