开发者

Specify expression in LIKE operator

开发者 https://www.devze.com 2022-12-11 17:47 出处:网络
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 (..)

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 '%..%'
0

精彩评论

暂无评论...
验证码 换一张
取 消