String MySQL

  1. Home
  2. MySQL
  3. String
  4. In some cases, pattern matches are equivalent to substring comparisons
Pattern match                      Substring comparison
str LIKE 'abc%'                    LEFT(str,3) = 'abc'
str LIKE '%abc'                    RIGHT(str,3) = 'abc'