[ar] [ast] [bg] [br] [ca] [co] [cpf] [cs] [da] [de] [en] [eo] [es] [eu] [fa] [fon] [fr] [gl] [id] [it] [ja] [lb] [nl] [oc] [pl] [pt] [ro] [ru] [sk] [sv] [tr] [uk] [vi] [zh] Espace de traduction


{criteria LIKE value}

August 2010 — updated on : July 2010

All the versions of this article:

The {... LIKE ...} criteria corresponds to the SQL comparison operator LIKE.

For example, we can search for AUTEURS (authors) whose login name starts with paul:
{login LIKE paul%}

We can also use a SPIP tag within the criteria, but you will need to enclose it by parentheses to obtain the tag’s value.

For example, searching for emails containing the value of the #ENV{email} tag:
{email LIKE %(#ENV{email})%}

As another example, we might try to find emails which do not contain the search criteria by writing:
{!email LIKE %(#ENV{email})%}

Show the template of this page Site powered by SPIP | Translation area | Private area