How to query an ampersand symbol in Postgres
I have a Postgres table that has names and addresses. Some of these name fields are both names of a couple -- for example, "John & Jane".
I am trying to write a query that pulls out only those rows where this is the case.
When I run this query, it selects 0 rows even though I know that they exist in the table:
SELECT count(*) FROM name_list where namefirst LIKE '%&%';
Does anyone know how to address this?
postgresql
asked Nov 21 '18 at 1:27
reallymemorable
151119
add a comment |
I have a Postgres table that has names and addresses. Some of these name fields are both names of a couple -- for example, "John & Jane".
I am trying to write a query that pulls out only those rows where this is the case.
When I run this query, it selects 0 rows even though I know that they exist in the table:
SELECT count(*) FROM name_list where namefirst LIKE '%&%';
Does anyone know how to address this?
postgresql
asked Nov 21 '18 at 1:27
reallymemorable
151119
LIKE '%&%'should be returning anynamefirstwhich has an ampersand in it. Check this demo where your logic is clearly working.
– Tim Biegeleisen
Nov 21 '18 at 1:34
Works for me!™ Are you running this query directly? Or as part of a larger program? If it's part of a larger program, please show us the code which is executing the query.
– Schwern
Nov 21 '18 at 5:23
add a comment |
I have a Postgres table that has names and addresses. Some of these name fields are both names of a couple -- for example, "John & Jane".
I am trying to write a query that pulls out only those rows where this is the case.
When I run this query, it selects 0 rows even though I know that they exist in the table:
SELECT count(*) FROM name_list where namefirst LIKE '%&%';
Does anyone know how to address this?
postgresql
asked Nov 21 '18 at 1:27
reallymemorable
151119
I have a Postgres table that has names and addresses. Some of these name fields are both names of a couple -- for example, "John & Jane".
I am trying to write a query that pulls out only those rows where this is the case.
When I run this query, it selects 0 rows even though I know that they exist in the table:
SELECT count(*) FROM name_list where namefirst LIKE '%&%';
Does anyone know how to address this?
postgresql
postgresql
asked Nov 21 '18 at 1:27
reallymemorable
151119
asked Nov 21 '18 at 1:27
reallymemorable
151119
asked Nov 21 '18 at 1:27
reallymemorable
151119
asked Nov 21 '18 at 1:27
reallymemorable
151119
asked Nov 21 '18 at 1:27
reallymemorable
151119
151119
LIKE '%&%'should be returning anynamefirstwhich has an ampersand in it. Check this demo where your logic is clearly working.
– Tim Biegeleisen
Nov 21 '18 at 1:34
Works for me!™ Are you running this query directly? Or as part of a larger program? If it's part of a larger program, please show us the code which is executing the query.
– Schwern
Nov 21 '18 at 5:23
add a comment |
LIKE '%&%'should be returning anynamefirstwhich has an ampersand in it. Check this demo where your logic is clearly working.
– Tim Biegeleisen
Nov 21 '18 at 1:34
Works for me!™ Are you running this query directly? Or as part of a larger program? If it's part of a larger program, please show us the code which is executing the query.
– Schwern
Nov 21 '18 at 5:23
LIKE '%&%' should be returning any namefirst which has an ampersand in it. Check this demo where your logic is clearly working.– Tim Biegeleisen
Nov 21 '18 at 1:34
LIKE '%&%' should be returning any namefirst which has an ampersand in it. Check this demo where your logic is clearly working.– Tim Biegeleisen
Nov 21 '18 at 1:34
Works for me!™ Are you running this query directly? Or as part of a larger program? If it's part of a larger program, please show us the code which is executing the query.
– Schwern
Nov 21 '18 at 5:23
Works for me!™ Are you running this query directly? Or as part of a larger program? If it's part of a larger program, please show us the code which is executing the query.
– Schwern
Nov 21 '18 at 5:23
add a comment |
0
active
oldest
votes
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
});
}
});
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%2f53404046%2fhow-to-query-an-ampersand-symbol-in-postgres%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
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%2f53404046%2fhow-to-query-an-ampersand-symbol-in-postgres%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
LIKE '%&%'should be returning anynamefirstwhich has an ampersand in it. Check this demo where your logic is clearly working.– Tim Biegeleisen
Nov 21 '18 at 1:34
Works for me!™ Are you running this query directly? Or as part of a larger program? If it's part of a larger program, please show us the code which is executing the query.
– Schwern
Nov 21 '18 at 5:23