Archive for November, 2009

BSNL 3G Speed

Posted on November 23, 2009, under Miscellaneous.

0

After a long awaiting for the actual launch of 3G service in Chennai, its available now. I rushed up to the customer service center and got myself the 3G Sim Card and just tried the net speed which BSNL claims

Search comma separated values db column in Rails

Posted on November 22, 2009, under MySQL, Rails.

0

I wanted to search for a value in DB and the column data is comma separated values say …

foo,bar,hey,hay

Now I wanted to find a record based on the value …say …hay

MySQL’s FIND_IN_SET comes into play and it works as follows

Model.find(:first, :conditions => ["FIND_IN_SET(?,search_column)", search_string])

Hope this helps!