AnsweredAssumed Answered

ExecuteSQL() exact word match

Question asked by mbraendle on Apr 18, 2013
Latest reply on Apr 19, 2013 by mbraendle

I'm trying to replicate the =word match in classic FileMaker Find by an ExecuteSQL() SELECT statement.


The only solution I have found so far for the WHERE part is


field LIKE 'word' OR field LIKE 'word %' OR field LIKE '% word' OR field LIKE '% word %'


Are there any simpler solutions?


A less wordy expression would be


field REXEXP '[[:<:]]word[[:>:]]'


but REGEXP is not supported by FileMaker.