Function in live SQL statement

xiaoxiao2021-03-06  44

1.2004.xx.xx

This retrieval condition is very simple, but the string to be retrieved contains a lot of illegal characters, so errors. Select * from ??? WHERE NAME LIKE '_FAFA'; eliminating it here _ because _ in certain places are wildcards. But Name Like '/ _fafa' escape '/' can not be used, so there is only to replace the function processing. Substr (name, '_ fafa') can solve the problem, because here _ can only be considered a string.

转载请注明原文地址:https://www.9cbs.com/read-76126.html

New Post(0)