The == operator

The == operator (or its inverse !==) is used for making record selections based on regular expressions. They can therefore enable extremely specific selection criteria, but may also be quite resource-intensive for the database manager.
<BOUCLEx(TABLES){field == expression}>
<BOUCLEx(TABLES){field !== expression}>

Example

Select articles with a title that starts with "The" or "the":
<BOUCLE_arts(ARTICLES){titre == ^[Tt]he}>
 - #TITRE<br />
</BOUCLE_arts>
Select article texts that do not contain the word "carnival":
<BOUCLE_arts(ARTICLES){texte !== 'carnival'}>
 - #TITRE<br />
</BOUCLE_arts>
Select article texts that do contain the word "carnival", but only if followed by the word "Venice" within 20 characters.
<BOUCLE_arts(ARTICLES){texte == 'carnival.{0,20}Venice'}>
 - #TITRE<br />
</BOUCLE_arts>

Author Mark Baber Published : Updated : 30/05/10

Translations : English, français, Nederlands