How do you handle wildcards when querying?

aquacn

Now in my query I want to query 15% of the data, but SQL will consider this percent sign as a wildcard, but I just want to query 15% of the data, what should I do?

prajna

Only the like operator will treat% as a wildcard, right? = No, right?

aquacn

Oh yes, it's a string match which contains 15%

prajna

create table # (a varchar (20))
insert into # select '15% '

select * from # where a = '15% '

sure. . .

cv4bf5d65fd

select * from tablename where column like '% 15 [%]%'

unkmass

A post previously discussed how to escape% into ordinary characters, the landlord may wish to search.

prajna

Then add another one?
select * from # where a like '15 %% '

prajna

Nope. . Ignore it. .

aquacn

TO:prajna
This will also query the data containing 15.

fanfan1980

select * from
(
select col = '15 '
union all select '% 15%'
union all select '% 15'
union all select '15% '
) a
where a.col = '15% '

--result
col
----
15%

(1 row (s) affected)