LiQL match is not accurate
Our data migration to khoros had a few misses, mainly, anything in our old forums with <code></code> tags is now a jumbled mess that I can fix manually by changing that to <li-code></li-code> in the ...
Forum Discussion
There's some good info here Search API Overview (khoros.com). I think you want to add double quotes inside the single quotes to signify that you want an exact match like this.
SELECT id, view_href, body, current_revision FROM messages where body MATCHES '"<CODE"' LIMIT 1
Thanks for trying to help! I had read that but he '" "' seemed to be for whitespace to make an exact match. That said, I tried that and no difference in results. code is being matched without the less than sign and case is being ignored.
Had a look and can't see any way to escape the < including trying a double character or a backslash, etc. I can't see any method of using a regex query either.
Maybe one for a support ticket to get a definitive answer. I'd be interested to find out if it's possible.
