Specify expression in LIKE operator
How can specify expression in LIKE operator
I want 开发者_运维问答to select all row in table where column Name starts with a-zA-Z followed by # and does not have two dots together (..)
i tries this WHERE NAME LIKE '%[a-zA-Z]#'
WHERE name LIKE '[a-zA-Z]#%' AND NOT (name LIKE '%..%')
WHERE Name LIKE '[A-Za-z]#%'
AND Name NOT LIKE '%..%'
精彩评论