Mega Code Archive

 

Categories / MySQL / String

 

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'