Text Contains | TEXT_CONTAINS
Syntax
TEXT_CONTAINS( [value], [search] )Parameters
value
The TEXT value
search
The TEXT value to search for.
It may also be a string representing a regular expression to search using a pattern.
Return Value
A BOOLEAN representing whether or not SEARCH is found in the VALUE.Description
Determine if a TEXT value contains another TEXT value or matches a pattern.Examples
TEXT_CONTAINS() # returns FALSETEXT_CONTAINS("text to search") # returns FALSETEXT_CONTAINS("text to search", "") # returns FALSETEXT_CONTAINS("text to search", "search") # returns TRUETEXT_CONTAINS("text to search", "not found") # returns FALSETEXT_CONTAINS("TEXT TO SEARCH", "/arch/") # returns FALSETEXT_CONTAINS("TEXT TO SEARCH", "/arch/i") # returns TRUE