Summary for String Functions
Understand key MySQL string functions, including pattern matching with LIKE and STRCMP, and master regular expressions using REGEXP_LIKE and related functions. Learn how to implement full-text search with BOOLEAN queries and query expansion to perform sophisticated text searches on CHAR, VARCHAR, and TEXT data types.
We'll cover the following...
We'll cover the following...
MySQL provides data types for five categories of data: numeric, date and time, string, spatial, and JSON. The comparison operator = provides equality matching for strings but does not support pattern matching. For that purpose, MySQL provides the LIKE operator and the STRCMP function. Both work well for base cases of ...