Hi All

I have a query that looks like the below:

select * from table where column1 like 'xxx' or column2 b like 'xxx' or column1 like 'yyy' or column2 like 'yyy' or column3 like 'xxxyyy' or column4 like 'xxxyyy'



Below is how i am implementing it in nhibernate but it is not working:
This query reads from the query string. It splits it into words and searches word by word.
When i send one word only in the querystring the below works fine but when i send more than one it returns nothing.


ICriteria crit = session.CreateCriteria(typeof(Cat));

string[] q = search.Replace(" ", "|").Split('|');
for (int i = 0; i < q.Length; i++)
{
crit.Add(Expression.Or(Expression.Like("culumn1", "%" + q[i].ToString() + "%"), Expression.Like("column2", "%" + q[i].ToString() + "%")));
}
crit.Add(Expression.Or(Expression.Like("column3", search.ToString()), Expression.Like("column4", search.ToString())));

Thanks in advance

is this a typo? 'culumn1'

turn on show_sql and I guess it will show you that you generate sql like



try using