say I have this in db:
Code:
f1 f2 
1 'cat folowing dog'
expected result:
Code:
1  cat
1  dog
How to do that ?
Case & like, would return only one row, first match.