Find descriptions that have 'taxes' as 2nd word The Next CEO of Stack OverflowSQL question: How can I extract this information from these tables?Finding duplicate values in a SQL tableFind all tables containing column with specified name - MS SQL Serveroracle 10g get all selected columns and datatype from a single select statementSQL Joins using ParentType and Parent Tablesstore separate select statements as tables before doing EXCEPT/ JOIN (t-sql)MYSQL query help- Substring and InstringSQL Join Query in MS AccessPostgreSQL joining multiple tablesSQL join statement between table and selection in Knex
How to write the block matrix in LaTex?
If I blow insulation everywhere in my attic except the door trap, will heat escape through it?
Inappropriate reference requests from Journal reviewers
Visit to the USA with ESTA approved before trip to Iran
Is a stroke of luck acceptable after a series of unfavorable events?
Should I tutor a student who I know has cheated on their homework?
Can the Reverse Gravity spell affect the Meteor Swarm spell?
Where to find order of arguments for default functions
Text adventure game code
Unreliable Magic - Is it worth it?
Are there languages with no euphemisms?
Opposite of a diet
Why do remote companies require working in the US?
Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis
The King's new dress
How do I get the green key off the shelf in the Dobby level of Lego Harry Potter 2?
Is it okay to store user locations?
Customer Requests (Sometimes) Drive Me Bonkers!
Too much space between section and text in a twocolumn document
Fastest way to shutdown Ubuntu Mate 18.10
Increase performance creating Mandelbrot set in python
How to Reset Passwords on Multiple Websites Easily?
How do spells that require an ability check vs. the caster's spell save DC work?
Only print output after finding pattern
Find descriptions that have 'taxes' as 2nd word
The Next CEO of Stack OverflowSQL question: How can I extract this information from these tables?Finding duplicate values in a SQL tableFind all tables containing column with specified name - MS SQL Serveroracle 10g get all selected columns and datatype from a single select statementSQL Joins using ParentType and Parent Tablesstore separate select statements as tables before doing EXCEPT/ JOIN (t-sql)MYSQL query help- Substring and InstringSQL Join Query in MS AccessPostgreSQL joining multiple tablesSQL join statement between table and selection in Knex
I am trying to write a statement that will output all of the descriptions that have taxes as the 2nd word. I am fairly confident with the first 4 lines but after that I am confused on how to do this. What I am will execute without error but it displays no information. Based on the information in my tables, there should be 7 things being displayed
SELECT vendor_name, account_description
FROM ap_vendors v
JOIN ap_general_ledger_accounts la
ON v.default_account_number = la.account_number
WHERE SUBSTR(LOWER(account_description),INSTR(account_description, ' ')) = 'taxes';
sql
asked Mar 21 at 16:19
user11119624user11119624
12
add a comment |
I am trying to write a statement that will output all of the descriptions that have taxes as the 2nd word. I am fairly confident with the first 4 lines but after that I am confused on how to do this. What I am will execute without error but it displays no information. Based on the information in my tables, there should be 7 things being displayed
SELECT vendor_name, account_description
FROM ap_vendors v
JOIN ap_general_ledger_accounts la
ON v.default_account_number = la.account_number
WHERE SUBSTR(LOWER(account_description),INSTR(account_description, ' ')) = 'taxes';
sql
asked Mar 21 at 16:19
user11119624user11119624
12
2
When you say second word, do you need to account for punctuation, spaces, etc? If the second "word" istaxesesesesthen is that a match or not? How robust do you need this to be? Do you have examples of the cases you need to cater for?
– MatBailie
Mar 21 at 16:24
2
Which DBMS product are you using? "SQL" is just a query language, not the name of a specific database product. Please add a tag for the database product you are usingpostgresql,oracle,sql-server,db2, ...
– a_horse_with_no_name
Mar 21 at 16:24
add a comment |
I am trying to write a statement that will output all of the descriptions that have taxes as the 2nd word. I am fairly confident with the first 4 lines but after that I am confused on how to do this. What I am will execute without error but it displays no information. Based on the information in my tables, there should be 7 things being displayed
SELECT vendor_name, account_description
FROM ap_vendors v
JOIN ap_general_ledger_accounts la
ON v.default_account_number = la.account_number
WHERE SUBSTR(LOWER(account_description),INSTR(account_description, ' ')) = 'taxes';
sql
asked Mar 21 at 16:19
user11119624user11119624
12
I am trying to write a statement that will output all of the descriptions that have taxes as the 2nd word. I am fairly confident with the first 4 lines but after that I am confused on how to do this. What I am will execute without error but it displays no information. Based on the information in my tables, there should be 7 things being displayed
SELECT vendor_name, account_description
FROM ap_vendors v
JOIN ap_general_ledger_accounts la
ON v.default_account_number = la.account_number
WHERE SUBSTR(LOWER(account_description),INSTR(account_description, ' ')) = 'taxes';
sql
sql
asked Mar 21 at 16:19
user11119624user11119624
12
asked Mar 21 at 16:19
user11119624user11119624
12
asked Mar 21 at 16:19
user11119624user11119624
12
asked Mar 21 at 16:19
user11119624user11119624
12
asked Mar 21 at 16:19
user11119624user11119624
12
12
2
When you say second word, do you need to account for punctuation, spaces, etc? If the second "word" istaxesesesesthen is that a match or not? How robust do you need this to be? Do you have examples of the cases you need to cater for?
– MatBailie
Mar 21 at 16:24
2
Which DBMS product are you using? "SQL" is just a query language, not the name of a specific database product. Please add a tag for the database product you are usingpostgresql,oracle,sql-server,db2, ...
– a_horse_with_no_name
Mar 21 at 16:24
add a comment |
2
When you say second word, do you need to account for punctuation, spaces, etc? If the second "word" istaxesesesesthen is that a match or not? How robust do you need this to be? Do you have examples of the cases you need to cater for?
– MatBailie
Mar 21 at 16:24
2
Which DBMS product are you using? "SQL" is just a query language, not the name of a specific database product. Please add a tag for the database product you are usingpostgresql,oracle,sql-server,db2, ...
– a_horse_with_no_name
Mar 21 at 16:24
2
2
When you say second word, do you need to account for punctuation, spaces, etc? If the second "word" is
taxeseseses then is that a match or not? How robust do you need this to be? Do you have examples of the cases you need to cater for?– MatBailie
Mar 21 at 16:24
When you say second word, do you need to account for punctuation, spaces, etc? If the second "word" is
taxeseseses then is that a match or not? How robust do you need this to be? Do you have examples of the cases you need to cater for?– MatBailie
Mar 21 at 16:24
2
2
Which DBMS product are you using? "SQL" is just a query language, not the name of a specific database product. Please add a tag for the database product you are using
postgresql, oracle, sql-server, db2, ...– a_horse_with_no_name
Mar 21 at 16:24
Which DBMS product are you using? "SQL" is just a query language, not the name of a specific database product. Please add a tag for the database product you are using
postgresql, oracle, sql-server, db2, ...– a_horse_with_no_name
Mar 21 at 16:24
add a comment |
2 Answers
2
active
oldest
votes
This can only work if 'taxes' is always the second and the last word.
If there are more words after taxes, it will not work.
Try Adding +1 to the 4th line.
WHERE SUBSTR(LOWER(account_description),INSTR(account_description, ' ')+1) = 'taxes';
answered Mar 21 at 16:27
Maris MolsMaris Mols
174
add a comment |
How about using LIKE:
WHERE account_description LIKE '% taxes%' AND
account_description NOT LIKE '% % taxes'
If your database supports regular expressions, you can use those as well.
answered Mar 21 at 17:33
Gordon LinoffGordon Linoff
791k35316419
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
);
);
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%2f55284942%2ffind-descriptions-that-have-taxes-as-2nd-word%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
This can only work if 'taxes' is always the second and the last word.
If there are more words after taxes, it will not work.
Try Adding +1 to the 4th line.
WHERE SUBSTR(LOWER(account_description),INSTR(account_description, ' ')+1) = 'taxes';
answered Mar 21 at 16:27
Maris MolsMaris Mols
174
add a comment |
This can only work if 'taxes' is always the second and the last word.
If there are more words after taxes, it will not work.
Try Adding +1 to the 4th line.
WHERE SUBSTR(LOWER(account_description),INSTR(account_description, ' ')+1) = 'taxes';
answered Mar 21 at 16:27
Maris MolsMaris Mols
174
add a comment |
This can only work if 'taxes' is always the second and the last word.
If there are more words after taxes, it will not work.
Try Adding +1 to the 4th line.
WHERE SUBSTR(LOWER(account_description),INSTR(account_description, ' ')+1) = 'taxes';
answered Mar 21 at 16:27
Maris MolsMaris Mols
174
This can only work if 'taxes' is always the second and the last word.
If there are more words after taxes, it will not work.
Try Adding +1 to the 4th line.
WHERE SUBSTR(LOWER(account_description),INSTR(account_description, ' ')+1) = 'taxes';
answered Mar 21 at 16:27
Maris MolsMaris Mols
174
answered Mar 21 at 16:27
Maris MolsMaris Mols
174
answered Mar 21 at 16:27
Maris MolsMaris Mols
174
answered Mar 21 at 16:27
Maris MolsMaris Mols
174
174
add a comment |
add a comment |
How about using LIKE:
WHERE account_description LIKE '% taxes%' AND
account_description NOT LIKE '% % taxes'
If your database supports regular expressions, you can use those as well.
answered Mar 21 at 17:33
Gordon LinoffGordon Linoff
791k35316419
add a comment |
How about using LIKE:
WHERE account_description LIKE '% taxes%' AND
account_description NOT LIKE '% % taxes'
If your database supports regular expressions, you can use those as well.
answered Mar 21 at 17:33
Gordon LinoffGordon Linoff
791k35316419
add a comment |
How about using LIKE:
WHERE account_description LIKE '% taxes%' AND
account_description NOT LIKE '% % taxes'
If your database supports regular expressions, you can use those as well.
answered Mar 21 at 17:33
Gordon LinoffGordon Linoff
791k35316419
How about using LIKE:
WHERE account_description LIKE '% taxes%' AND
account_description NOT LIKE '% % taxes'
If your database supports regular expressions, you can use those as well.
answered Mar 21 at 17:33
Gordon LinoffGordon Linoff
791k35316419
answered Mar 21 at 17:33
Gordon LinoffGordon Linoff
791k35316419
answered Mar 21 at 17:33
Gordon LinoffGordon Linoff
791k35316419
answered Mar 21 at 17:33
Gordon LinoffGordon Linoff
791k35316419
791k35316419
add a comment |
add a comment |
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.
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%2f55284942%2ffind-descriptions-that-have-taxes-as-2nd-word%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
2
When you say second word, do you need to account for punctuation, spaces, etc? If the second "word" is
taxesesesesthen is that a match or not? How robust do you need this to be? Do you have examples of the cases you need to cater for?– MatBailie
Mar 21 at 16:24
2
Which DBMS product are you using? "SQL" is just a query language, not the name of a specific database product. Please add a tag for the database product you are using
postgresql,oracle,sql-server,db2, ...– a_horse_with_no_name
Mar 21 at 16:24