Home / cs-notes / Architecture / Components / Database / MySQL / questions / 子串匹配
like
- %str
- str%
- %str%
locate
-
locate(substr, str,
[pos]
) -
same as: position(substr in str)
find_in_set
- instr(str, substr)
Home / cs-notes / Architecture / Components / Database / MySQL / questions / 子串匹配
locate(substr, str, [pos]
)
same as: position(substr in str)