I tried :
我试着:
Use SchoolDB
Select Distinct Surnames from Students
where Surname LIKE '%^@%'
above I get zero values.
上面是0。
I also tried replacing '%^@%' with '%[!@]%' or '%[^@]%'
我也尝试过“% ^ @ %”替换为“%(!@]%”或“%[^ @]% '
2 个解决方案
#1
4
SELECT
DISTINCT Surnames
FROM Students
WHERE
Surname NOT LIKE '%@%'
#2
1
You can use NOT LIKE, like this:
你可以用不喜欢，像这样:
where Surname NOT LIKE '%[@]%'
Expect it helps.
希望它可以帮助。
#1
4
SELECT
DISTINCT Surnames
FROM Students
WHERE
Surname NOT LIKE '%@%'
#2
1
You can use NOT LIKE, like this:
你可以用不喜欢，像这样:
where Surname NOT LIKE '%[@]%'
Expect it helps.
希望它可以帮助。