how can put if condition in where clause
1
Please don't put duplicate with question IF clause within WHERE clause ?
I think my question is difference, I have been tryed but I can't not run success with condition below.
How can put if condition between where in sql
for example
SELECT *
FROM LocationOutsw W
WHERE if(@p_type = 'ALL') then
(W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%')
if(@p_type == "NAME")
W.NAME LIKE '%'+ @p_search + '%'
if(@p_type == "DESCRIPTION ")
W.DESCRIPTION LIKE '%'+ @p_search + '%')
sql
sql-server edited Nov 16 '18 at 7:57
Sami
9,29331244
asked Nov 16 '18 at 7:56
Hong Van VitHong Van Vit
1,585324
add a comment |
1
Please don't put duplicate with question IF clause within WHERE clause ?
I think my question is difference, I have been tryed but I can't not run success with condition below.
How can put if condition between where in sql
for example
SELECT *
FROM LocationOutsw W
WHERE if(@p_type = 'ALL') then
(W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%')
if(@p_type == "NAME")
W.NAME LIKE '%'+ @p_search + '%'
if(@p_type == "DESCRIPTION ")
W.DESCRIPTION LIKE '%'+ @p_search + '%')
sql
sql-server edited Nov 16 '18 at 7:57
Sami
9,29331244
asked Nov 16 '18 at 7:56
Hong Van VitHong Van Vit
1,585324
Are you using MySQL, MS SQL Server or Oracle? That query will run on max one of them.
– jarlh
Nov 16 '18 at 7:57
add a comment |
1
1
1
Please don't put duplicate with question IF clause within WHERE clause ?
I think my question is difference, I have been tryed but I can't not run success with condition below.
How can put if condition between where in sql
for example
SELECT *
FROM LocationOutsw W
WHERE if(@p_type = 'ALL') then
(W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%')
if(@p_type == "NAME")
W.NAME LIKE '%'+ @p_search + '%'
if(@p_type == "DESCRIPTION ")
W.DESCRIPTION LIKE '%'+ @p_search + '%')
sql
sql-server edited Nov 16 '18 at 7:57
Sami
9,29331244
asked Nov 16 '18 at 7:56
Hong Van VitHong Van Vit
1,585324
Please don't put duplicate with question IF clause within WHERE clause ?
I think my question is difference, I have been tryed but I can't not run success with condition below.
How can put if condition between where in sql
for example
SELECT *
FROM LocationOutsw W
WHERE if(@p_type = 'ALL') then
(W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%')
if(@p_type == "NAME")
W.NAME LIKE '%'+ @p_search + '%'
if(@p_type == "DESCRIPTION ")
W.DESCRIPTION LIKE '%'+ @p_search + '%')
sql
sql-server sql
sql-server edited Nov 16 '18 at 7:57
Sami
9,29331244
asked Nov 16 '18 at 7:56
Hong Van VitHong Van Vit
1,585324
edited Nov 16 '18 at 7:57
Sami
9,29331244
asked Nov 16 '18 at 7:56
Hong Van VitHong Van Vit
1,585324
edited Nov 16 '18 at 7:57
Sami
9,29331244
edited Nov 16 '18 at 7:57
Sami
9,29331244
edited Nov 16 '18 at 7:57
Sami
9,29331244
9,29331244
asked Nov 16 '18 at 7:56
Hong Van VitHong Van Vit
1,585324
asked Nov 16 '18 at 7:56
Hong Van VitHong Van Vit
1,585324
asked Nov 16 '18 at 7:56
Hong Van VitHong Van Vit
1,585324
1,585324
Are you using MySQL, MS SQL Server or Oracle? That query will run on max one of them.
– jarlh
Nov 16 '18 at 7:57
add a comment |
Are you using MySQL, MS SQL Server or Oracle? That query will run on max one of them.
– jarlh
Nov 16 '18 at 7:57
Are you using MySQL, MS SQL Server or Oracle? That query will run on max one of them.
– jarlh
Nov 16 '18 at 7:57
Are you using MySQL, MS SQL Server or Oracle? That query will run on max one of them.
– jarlh
Nov 16 '18 at 7:57
add a comment |
3 Answers
3
active
oldest
votes
3
SELECT *
FROM LocationOutsw W
WHERE ( @p_type = 'ALL'
AND ( W.NAME LIKE '%'+ @p_search + '%'
OR W.DESCRIPTION LIKE '%'+ @p_search + '%'
)
)
OR ( @p_type = 'NAME'
AND W.NAME LIKE '%'+ @p_search + '%'
)
OR ( @p_type = 'DESCRIPTION'
AND W.DESCRIPTION LIKE '%'+ @p_search + '%'
)
But I strongly recommend not to write your queries like so, because of wrong query plans you will get.
answered Nov 16 '18 at 8:02
Denis RubashkinDenis Rubashkin
1,5611311
It realy done. Thank you.
– Hong Van Vit
Nov 16 '18 at 8:40
add a comment |
2
I would use boolean expressions for this
SELECT *
FROM LocationOutsw W
WHERE (@p_type = 'ALL' and W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%')
or (@p_type = 'NAME' and W.NAME LIKE '%'+ @p_search + '%')
or (@p_type = 'DESCRIPTION' and W.DESCRIPTION LIKE '%'+ @p_search + '%')
Be careful in syntax. Apostrophes have a different meaning than quotation mark.
answered Nov 16 '18 at 8:03
Radim BačaRadim Bača
8,89611226
add a comment |
2
I would recommended this way.. It will do better..
SELECT
*
FROM
LocationOutsw W
WHERE
(@p_type = 'ALL' AND
(W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%'))
OR
(@p_type = 'NAME' AND W.NAME LIKE '%'+ @p_search + '%')
OR
(@p_type = 'DESCRIPTION' AND W.DESCRIPTION LIKE '%'+ @p_search + '%')
And ' Single quote for String not " Double Quote..
answered Nov 16 '18 at 8:06
dwir182dwir182
1,445619
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53333607%2fhow-can-put-if-condition-in-where-clause%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
3
SELECT *
FROM LocationOutsw W
WHERE ( @p_type = 'ALL'
AND ( W.NAME LIKE '%'+ @p_search + '%'
OR W.DESCRIPTION LIKE '%'+ @p_search + '%'
)
)
OR ( @p_type = 'NAME'
AND W.NAME LIKE '%'+ @p_search + '%'
)
OR ( @p_type = 'DESCRIPTION'
AND W.DESCRIPTION LIKE '%'+ @p_search + '%'
)
But I strongly recommend not to write your queries like so, because of wrong query plans you will get.
answered Nov 16 '18 at 8:02
Denis RubashkinDenis Rubashkin
1,5611311
It realy done. Thank you.
– Hong Van Vit
Nov 16 '18 at 8:40
add a comment |
3
SELECT *
FROM LocationOutsw W
WHERE ( @p_type = 'ALL'
AND ( W.NAME LIKE '%'+ @p_search + '%'
OR W.DESCRIPTION LIKE '%'+ @p_search + '%'
)
)
OR ( @p_type = 'NAME'
AND W.NAME LIKE '%'+ @p_search + '%'
)
OR ( @p_type = 'DESCRIPTION'
AND W.DESCRIPTION LIKE '%'+ @p_search + '%'
)
But I strongly recommend not to write your queries like so, because of wrong query plans you will get.
answered Nov 16 '18 at 8:02
Denis RubashkinDenis Rubashkin
1,5611311
It realy done. Thank you.
– Hong Van Vit
Nov 16 '18 at 8:40
add a comment |
3
3
3
SELECT *
FROM LocationOutsw W
WHERE ( @p_type = 'ALL'
AND ( W.NAME LIKE '%'+ @p_search + '%'
OR W.DESCRIPTION LIKE '%'+ @p_search + '%'
)
)
OR ( @p_type = 'NAME'
AND W.NAME LIKE '%'+ @p_search + '%'
)
OR ( @p_type = 'DESCRIPTION'
AND W.DESCRIPTION LIKE '%'+ @p_search + '%'
)
But I strongly recommend not to write your queries like so, because of wrong query plans you will get.
answered Nov 16 '18 at 8:02
Denis RubashkinDenis Rubashkin
1,5611311
SELECT *
FROM LocationOutsw W
WHERE ( @p_type = 'ALL'
AND ( W.NAME LIKE '%'+ @p_search + '%'
OR W.DESCRIPTION LIKE '%'+ @p_search + '%'
)
)
OR ( @p_type = 'NAME'
AND W.NAME LIKE '%'+ @p_search + '%'
)
OR ( @p_type = 'DESCRIPTION'
AND W.DESCRIPTION LIKE '%'+ @p_search + '%'
)
But I strongly recommend not to write your queries like so, because of wrong query plans you will get.
answered Nov 16 '18 at 8:02
Denis RubashkinDenis Rubashkin
1,5611311
answered Nov 16 '18 at 8:02
Denis RubashkinDenis Rubashkin
1,5611311
answered Nov 16 '18 at 8:02
Denis RubashkinDenis Rubashkin
1,5611311
answered Nov 16 '18 at 8:02
Denis RubashkinDenis Rubashkin
1,5611311
1,5611311
It realy done. Thank you.
– Hong Van Vit
Nov 16 '18 at 8:40
add a comment |
It realy done. Thank you.
– Hong Van Vit
Nov 16 '18 at 8:40
It realy done. Thank you.
– Hong Van Vit
Nov 16 '18 at 8:40
It realy done. Thank you.
– Hong Van Vit
Nov 16 '18 at 8:40
add a comment |
2
I would use boolean expressions for this
SELECT *
FROM LocationOutsw W
WHERE (@p_type = 'ALL' and W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%')
or (@p_type = 'NAME' and W.NAME LIKE '%'+ @p_search + '%')
or (@p_type = 'DESCRIPTION' and W.DESCRIPTION LIKE '%'+ @p_search + '%')
Be careful in syntax. Apostrophes have a different meaning than quotation mark.
answered Nov 16 '18 at 8:03
Radim BačaRadim Bača
8,89611226
add a comment |
2
I would use boolean expressions for this
SELECT *
FROM LocationOutsw W
WHERE (@p_type = 'ALL' and W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%')
or (@p_type = 'NAME' and W.NAME LIKE '%'+ @p_search + '%')
or (@p_type = 'DESCRIPTION' and W.DESCRIPTION LIKE '%'+ @p_search + '%')
Be careful in syntax. Apostrophes have a different meaning than quotation mark.
answered Nov 16 '18 at 8:03
Radim BačaRadim Bača
8,89611226
add a comment |
2
2
2
I would use boolean expressions for this
SELECT *
FROM LocationOutsw W
WHERE (@p_type = 'ALL' and W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%')
or (@p_type = 'NAME' and W.NAME LIKE '%'+ @p_search + '%')
or (@p_type = 'DESCRIPTION' and W.DESCRIPTION LIKE '%'+ @p_search + '%')
Be careful in syntax. Apostrophes have a different meaning than quotation mark.
answered Nov 16 '18 at 8:03
Radim BačaRadim Bača
8,89611226
I would use boolean expressions for this
SELECT *
FROM LocationOutsw W
WHERE (@p_type = 'ALL' and W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%')
or (@p_type = 'NAME' and W.NAME LIKE '%'+ @p_search + '%')
or (@p_type = 'DESCRIPTION' and W.DESCRIPTION LIKE '%'+ @p_search + '%')
Be careful in syntax. Apostrophes have a different meaning than quotation mark.
answered Nov 16 '18 at 8:03
Radim BačaRadim Bača
8,89611226
answered Nov 16 '18 at 8:03
Radim BačaRadim Bača
8,89611226
answered Nov 16 '18 at 8:03
Radim BačaRadim Bača
8,89611226
answered Nov 16 '18 at 8:03
Radim BačaRadim Bača
8,89611226
8,89611226
add a comment |
add a comment |
2
I would recommended this way.. It will do better..
SELECT
*
FROM
LocationOutsw W
WHERE
(@p_type = 'ALL' AND
(W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%'))
OR
(@p_type = 'NAME' AND W.NAME LIKE '%'+ @p_search + '%')
OR
(@p_type = 'DESCRIPTION' AND W.DESCRIPTION LIKE '%'+ @p_search + '%')
And ' Single quote for String not " Double Quote..
answered Nov 16 '18 at 8:06
dwir182dwir182
1,445619
add a comment |
2
I would recommended this way.. It will do better..
SELECT
*
FROM
LocationOutsw W
WHERE
(@p_type = 'ALL' AND
(W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%'))
OR
(@p_type = 'NAME' AND W.NAME LIKE '%'+ @p_search + '%')
OR
(@p_type = 'DESCRIPTION' AND W.DESCRIPTION LIKE '%'+ @p_search + '%')
And ' Single quote for String not " Double Quote..
answered Nov 16 '18 at 8:06
dwir182dwir182
1,445619
add a comment |
2
2
2
I would recommended this way.. It will do better..
SELECT
*
FROM
LocationOutsw W
WHERE
(@p_type = 'ALL' AND
(W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%'))
OR
(@p_type = 'NAME' AND W.NAME LIKE '%'+ @p_search + '%')
OR
(@p_type = 'DESCRIPTION' AND W.DESCRIPTION LIKE '%'+ @p_search + '%')
And ' Single quote for String not " Double Quote..
answered Nov 16 '18 at 8:06
dwir182dwir182
1,445619
I would recommended this way.. It will do better..
SELECT
*
FROM
LocationOutsw W
WHERE
(@p_type = 'ALL' AND
(W.NAME LIKE '%'+ @p_search + '%' OR W.DESCRIPTION LIKE '%'+ @p_search + '%'))
OR
(@p_type = 'NAME' AND W.NAME LIKE '%'+ @p_search + '%')
OR
(@p_type = 'DESCRIPTION' AND W.DESCRIPTION LIKE '%'+ @p_search + '%')
And ' Single quote for String not " Double Quote..
answered Nov 16 '18 at 8:06
dwir182dwir182
1,445619
edited Nov 16 '18 at 8:25
answered Nov 16 '18 at 8:06
dwir182dwir182
1,445619
answered Nov 16 '18 at 8:06
dwir182dwir182
1,445619
answered Nov 16 '18 at 8:06
dwir182dwir182
1,445619
1,445619
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53333607%2fhow-can-put-if-condition-in-where-clause%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Are you using MySQL, MS SQL Server or Oracle? That query will run on max one of them.
– jarlh
Nov 16 '18 at 7:57