smart LIKE?
smart LIKE?
- Subject: smart LIKE?
- From: OC <email@hidden>
- Date: Wed, 04 Feb 2015 08:22:21 +0100
Hello there,
I've just bumped into a need to fetch based on a textual qualifier which I can't create. My records in one column contain tab-separated pairs of tags and text, like in
"foo:foo value<TAB>bar:blahblah<TAB>bax:this is the value of bax"
I need to fetch the rows whose value of given tag contains a string.
If it were "begins with", the solution would be a simple LIKE, but with "contains", the problem is that e.g., "LIKE '%fooºx'" would select the sample row above, although the value for 'foo' is 'foo value' and does not contain 'bax' at all.
Is there some trick to do this at fetch with some smart qualifier (in FrontBase)? Or is there no better approach than to fetch all "LIKE '%fooºx'" rows, and filter them further in memory e.g., using a regexp?
Thanks a lot,
OC
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden