Search in sqlite table where column matches regex

Question

Hi,

I'm writing a web application in Rails which uses sqlite. I want the user to be able to search a table in the database by using a regex. Is this possible? Thanks.

Answer 1

yes there is a regexp operator.. But you have to implement the function.