Record not getting filtered using like clause

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;

up vote
1
down vote

favorite

Using below query to filter records:

select * from SearchRecord where searchkeyword1 like '[%'

Tried this also

select * from SearchRecord where searchkeyword1 like '%[%'

Records in table contain these values (as per below i need last 2 records, why this simple like won't filter records)

"Affiliate" means
"Agent's Rate of Exchange" means
["Aggregate Total Commitments" means
["Agreed Security Principles" means

asked 37 mins ago

user3657339

273

add a commentÂ |Â

up vote
1
down vote

favorite

Using below query to filter records:

select * from SearchRecord where searchkeyword1 like '[%'

Tried this also

select * from SearchRecord where searchkeyword1 like '%[%'

Records in table contain these values (as per below i need last 2 records, why this simple like won't filter records)

"Affiliate" means
"Agent's Rate of Exchange" means
["Aggregate Total Commitments" means
["Agreed Security Principles" means

asked 37 mins ago

user3657339

273

add a commentÂ |Â

up vote
1
down vote

favorite

Using below query to filter records:

select * from SearchRecord where searchkeyword1 like '[%'

Tried this also

select * from SearchRecord where searchkeyword1 like '%[%'

Records in table contain these values (as per below i need last 2 records, why this simple like won't filter records)

"Affiliate" means
"Agent's Rate of Exchange" means
["Aggregate Total Commitments" means
["Agreed Security Principles" means

asked 37 mins ago

user3657339

273

Using below query to filter records:

select * from SearchRecord where searchkeyword1 like '[%'

Tried this also

select * from SearchRecord where searchkeyword1 like '%[%'

Records in table contain these values (as per below i need last 2 records, why this simple like won't filter records)

"Affiliate" means
"Agent's Rate of Exchange" means
["Aggregate Total Commitments" means
["Agreed Security Principles" means

sql-server

asked 37 mins ago

user3657339

273

asked 37 mins ago

user3657339

273

asked 37 mins ago

user3657339

273

asked 37 mins ago

user3657339

273

asked 37 mins ago

user3657339

273

add a commentÂ |Â

2 Answers
2

active

oldest

votes

up vote
3
down vote

accepted

Your search pattern contains a wildcard character [,
you should enclose it in brackets or use ESCAPE character like this:

declare @SearchRecord table (searchkeyword1 varchar(100));
insert into @SearchRecord values
('"Affiliate" means'),
('"Agent''''s Rate of Exchange" means'),
('["Aggregate Total Commitments" means'),
('["Agreed Security Principles" means');

select * 
from @SearchRecord 
where searchkeyword1 like '![%' ESCAPE '!';

select * 
from @SearchRecord 
where searchkeyword1 like '[%';

All this is described here:
LIKE (Transact-SQL)

answered 19 mins ago

sepupic

6,203716

add a commentÂ |Â

up vote
1
down vote

You can use ESCAPE '<some char>' to tell SQL how to interpret the character after .

SELECT * FROM SearchRecord WHERE SearchKeyword LIKE '%[%' ESCAPE '';

db<>fiddle here

answered 18 mins ago

McNets

13.1k41554

add a commentÂ |Â

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f221240%2frecord-not-getting-filtered-using-like-clause%23new-answer', 'question_page');

);

Post as a guest

Name

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

up vote
3
down vote

accepted

Your search pattern contains a wildcard character [,
you should enclose it in brackets or use ESCAPE character like this:

declare @SearchRecord table (searchkeyword1 varchar(100));
insert into @SearchRecord values
('"Affiliate" means'),
('"Agent''''s Rate of Exchange" means'),
('["Aggregate Total Commitments" means'),
('["Agreed Security Principles" means');

select * 
from @SearchRecord 
where searchkeyword1 like '![%' ESCAPE '!';

select * 
from @SearchRecord 
where searchkeyword1 like '[%';

All this is described here:
LIKE (Transact-SQL)

answered 19 mins ago

sepupic

6,203716

add a commentÂ |Â

up vote
3
down vote

accepted

Your search pattern contains a wildcard character [,
you should enclose it in brackets or use ESCAPE character like this:

declare @SearchRecord table (searchkeyword1 varchar(100));
insert into @SearchRecord values
('"Affiliate" means'),
('"Agent''''s Rate of Exchange" means'),
('["Aggregate Total Commitments" means'),
('["Agreed Security Principles" means');

select * 
from @SearchRecord 
where searchkeyword1 like '![%' ESCAPE '!';

select * 
from @SearchRecord 
where searchkeyword1 like '[%';

All this is described here:
LIKE (Transact-SQL)

answered 19 mins ago

sepupic

6,203716

add a commentÂ |Â

up vote
3
down vote

accepted

Your search pattern contains a wildcard character [,
you should enclose it in brackets or use ESCAPE character like this:

declare @SearchRecord table (searchkeyword1 varchar(100));
insert into @SearchRecord values
('"Affiliate" means'),
('"Agent''''s Rate of Exchange" means'),
('["Aggregate Total Commitments" means'),
('["Agreed Security Principles" means');

select * 
from @SearchRecord 
where searchkeyword1 like '![%' ESCAPE '!';

select * 
from @SearchRecord 
where searchkeyword1 like '[%';

All this is described here:
LIKE (Transact-SQL)

answered 19 mins ago

sepupic

6,203716

Your search pattern contains a wildcard character [,
you should enclose it in brackets or use ESCAPE character like this:

declare @SearchRecord table (searchkeyword1 varchar(100));
insert into @SearchRecord values
('"Affiliate" means'),
('"Agent''''s Rate of Exchange" means'),
('["Aggregate Total Commitments" means'),
('["Agreed Security Principles" means');

select * 
from @SearchRecord 
where searchkeyword1 like '![%' ESCAPE '!';

select * 
from @SearchRecord 
where searchkeyword1 like '[%';

All this is described here:
LIKE (Transact-SQL)

answered 19 mins ago

sepupic

6,203716

answered 19 mins ago

sepupic

6,203716

answered 19 mins ago

sepupic

6,203716

answered 19 mins ago

sepupic

6,203716

add a commentÂ |Â

up vote
1
down vote

You can use ESCAPE '<some char>' to tell SQL how to interpret the character after .

SELECT * FROM SearchRecord WHERE SearchKeyword LIKE '%[%' ESCAPE '';

db<>fiddle here

answered 18 mins ago

McNets

13.1k41554

add a commentÂ |Â

up vote
1
down vote

You can use ESCAPE '<some char>' to tell SQL how to interpret the character after .

SELECT * FROM SearchRecord WHERE SearchKeyword LIKE '%[%' ESCAPE '';

db<>fiddle here

answered 18 mins ago

McNets

13.1k41554

add a commentÂ |Â

up vote
1
down vote

You can use ESCAPE '<some char>' to tell SQL how to interpret the character after .

SELECT * FROM SearchRecord WHERE SearchKeyword LIKE '%[%' ESCAPE '';

db<>fiddle here

answered 18 mins ago

McNets

13.1k41554

You can use ESCAPE '<some char>' to tell SQL how to interpret the character after .

SELECT * FROM SearchRecord WHERE SearchKeyword LIKE '%[%' ESCAPE '';

db<>fiddle here

answered 18 mins ago

McNets

13.1k41554

answered 18 mins ago

McNets

13.1k41554

answered 18 mins ago

McNets

13.1k41554

answered 18 mins ago

McNets

13.1k41554

add a commentÂ |Â

draft saved

draft discarded

draft saved

draft discarded

Post as a guest

Name

Search This Blog

Iyfjky