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.