Filter the entries shown upon SELECT in MariaDB
I have entries in a certain mariadb table with values in a column named code like:
ABC-SI-GR-0
ABC-SI-NAV-0
ABC-GO-NAV-0
ABC-SI-NAV-3P
ABC-GO-GR-0
ABC-GO-GR-3P
...
... and so on
now I want to SELECT all entries from that table which have SI as a part of the string in the code column. I have tried
SELECT * WHERE code LIKE %SI% FROM [table]
which did not work.
check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE code LIKE %SI% FROM [table]' at line 1
Can anyone point me to a more successful kind of syntax for such?
mariadb
asked Jan 24 at 13:10
vrmsvrms
1
migrated from superuser.com Jan 24 at 13:34
This question came from our site for computer enthusiasts and power users.
add a comment |
I have entries in a certain mariadb table with values in a column named code like:
ABC-SI-GR-0
ABC-SI-NAV-0
ABC-GO-NAV-0
ABC-SI-NAV-3P
ABC-GO-GR-0
ABC-GO-GR-3P
...
... and so on
now I want to SELECT all entries from that table which have SI as a part of the string in the code column. I have tried
SELECT * WHERE code LIKE %SI% FROM [table]
which did not work.
check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE code LIKE %SI% FROM [table]' at line 1
Can anyone point me to a more successful kind of syntax for such?
mariadb
asked Jan 24 at 13:10
vrmsvrms
1
migrated from superuser.com Jan 24 at 13:34
This question came from our site for computer enthusiasts and power users.
add a comment |
I have entries in a certain mariadb table with values in a column named code like:
ABC-SI-GR-0
ABC-SI-NAV-0
ABC-GO-NAV-0
ABC-SI-NAV-3P
ABC-GO-GR-0
ABC-GO-GR-3P
...
... and so on
now I want to SELECT all entries from that table which have SI as a part of the string in the code column. I have tried
SELECT * WHERE code LIKE %SI% FROM [table]
which did not work.
check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE code LIKE %SI% FROM [table]' at line 1
Can anyone point me to a more successful kind of syntax for such?
mariadb
asked Jan 24 at 13:10
vrmsvrms
1
I have entries in a certain mariadb table with values in a column named code like:
ABC-SI-GR-0
ABC-SI-NAV-0
ABC-GO-NAV-0
ABC-SI-NAV-3P
ABC-GO-GR-0
ABC-GO-GR-3P
...
... and so on
now I want to SELECT all entries from that table which have SI as a part of the string in the code column. I have tried
SELECT * WHERE code LIKE %SI% FROM [table]
which did not work.
check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE code LIKE %SI% FROM [table]' at line 1
Can anyone point me to a more successful kind of syntax for such?
mariadb
mariadb
asked Jan 24 at 13:10
vrmsvrms
1
asked Jan 24 at 13:10
vrmsvrms
1
asked Jan 24 at 13:10
vrmsvrms
1
asked Jan 24 at 13:10
vrmsvrms
1
asked Jan 24 at 13:10
vrmsvrms
1
1
migrated from superuser.com Jan 24 at 13:34
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Jan 24 at 13:34
This question came from our site for computer enthusiasts and power users.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Your are missing quotes around your like clause. Change your select to:
SELECT * FROM [table] WHERE code LIKE '%SI%'
answered Jan 24 at 13:41
DaveDave
2,73981730
Additionally, usingrlikeinstead oflikecan be quicker since it is using a regex vs. globbing.select * where code rlike 'SI' from tablename
– ivanivan
Jan 24 at 13:59
1
Possibly butrlikeis not multi-byte safe which could cause other issues.
– Dave
Jan 24 at 14:01
thx for the pointer @Dave. adding quotes (of any type. tried "...", '...', ` ... `) result in the same error as before unfortunately. LIKE or RLIKE doesn't make adifference in that regards. Any other ideas?
– vrms
Jan 24 at 14:21
Please modify your question with the exact statement you are using now and the complete error you are getting.
– Dave
Jan 24 at 14:25
SELECT * FROM [table] WHERE code LIKE '%SI%'works though
– vrms
Jan 24 at 14:31
|
show 4 more comments
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%2f54347888%2ffilter-the-entries-shown-upon-select-in-mariadb%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Your are missing quotes around your like clause. Change your select to:
SELECT * FROM [table] WHERE code LIKE '%SI%'
answered Jan 24 at 13:41
DaveDave
2,73981730
Additionally, usingrlikeinstead oflikecan be quicker since it is using a regex vs. globbing.select * where code rlike 'SI' from tablename
– ivanivan
Jan 24 at 13:59
1
Possibly butrlikeis not multi-byte safe which could cause other issues.
– Dave
Jan 24 at 14:01
thx for the pointer @Dave. adding quotes (of any type. tried "...", '...', ` ... `) result in the same error as before unfortunately. LIKE or RLIKE doesn't make adifference in that regards. Any other ideas?
– vrms
Jan 24 at 14:21
Please modify your question with the exact statement you are using now and the complete error you are getting.
– Dave
Jan 24 at 14:25
SELECT * FROM [table] WHERE code LIKE '%SI%'works though
– vrms
Jan 24 at 14:31
|
show 4 more comments
Your are missing quotes around your like clause. Change your select to:
SELECT * FROM [table] WHERE code LIKE '%SI%'
answered Jan 24 at 13:41
DaveDave
2,73981730
Additionally, usingrlikeinstead oflikecan be quicker since it is using a regex vs. globbing.select * where code rlike 'SI' from tablename
– ivanivan
Jan 24 at 13:59
1
Possibly butrlikeis not multi-byte safe which could cause other issues.
– Dave
Jan 24 at 14:01
thx for the pointer @Dave. adding quotes (of any type. tried "...", '...', ` ... `) result in the same error as before unfortunately. LIKE or RLIKE doesn't make adifference in that regards. Any other ideas?
– vrms
Jan 24 at 14:21
Please modify your question with the exact statement you are using now and the complete error you are getting.
– Dave
Jan 24 at 14:25
SELECT * FROM [table] WHERE code LIKE '%SI%'works though
– vrms
Jan 24 at 14:31
|
show 4 more comments
Your are missing quotes around your like clause. Change your select to:
SELECT * FROM [table] WHERE code LIKE '%SI%'
answered Jan 24 at 13:41
DaveDave
2,73981730
Your are missing quotes around your like clause. Change your select to:
SELECT * FROM [table] WHERE code LIKE '%SI%'
answered Jan 24 at 13:41
DaveDave
2,73981730
edited Jan 24 at 14:37
answered Jan 24 at 13:41
DaveDave
2,73981730
answered Jan 24 at 13:41
DaveDave
2,73981730
answered Jan 24 at 13:41
DaveDave
2,73981730
2,73981730
Additionally, usingrlikeinstead oflikecan be quicker since it is using a regex vs. globbing.select * where code rlike 'SI' from tablename
– ivanivan
Jan 24 at 13:59
1
Possibly butrlikeis not multi-byte safe which could cause other issues.
– Dave
Jan 24 at 14:01
thx for the pointer @Dave. adding quotes (of any type. tried "...", '...', ` ... `) result in the same error as before unfortunately. LIKE or RLIKE doesn't make adifference in that regards. Any other ideas?
– vrms
Jan 24 at 14:21
Please modify your question with the exact statement you are using now and the complete error you are getting.
– Dave
Jan 24 at 14:25
SELECT * FROM [table] WHERE code LIKE '%SI%'works though
– vrms
Jan 24 at 14:31
|
show 4 more comments
Additionally, usingrlikeinstead oflikecan be quicker since it is using a regex vs. globbing.select * where code rlike 'SI' from tablename
– ivanivan
Jan 24 at 13:59
1
Possibly butrlikeis not multi-byte safe which could cause other issues.
– Dave
Jan 24 at 14:01
thx for the pointer @Dave. adding quotes (of any type. tried "...", '...', ` ... `) result in the same error as before unfortunately. LIKE or RLIKE doesn't make adifference in that regards. Any other ideas?
– vrms
Jan 24 at 14:21
Please modify your question with the exact statement you are using now and the complete error you are getting.
– Dave
Jan 24 at 14:25
SELECT * FROM [table] WHERE code LIKE '%SI%'works though
– vrms
Jan 24 at 14:31
Additionally, using
rlike instead of like can be quicker since it is using a regex vs. globbing. select * where code rlike 'SI' from tablename– ivanivan
Jan 24 at 13:59
Additionally, using
rlike instead of like can be quicker since it is using a regex vs. globbing. select * where code rlike 'SI' from tablename– ivanivan
Jan 24 at 13:59
1
1
Possibly but
rlike is not multi-byte safe which could cause other issues.– Dave
Jan 24 at 14:01
Possibly but
rlike is not multi-byte safe which could cause other issues.– Dave
Jan 24 at 14:01
thx for the pointer @Dave. adding quotes (of any type. tried "...", '...', ` ... `) result in the same error as before unfortunately. LIKE or RLIKE doesn't make adifference in that regards. Any other ideas?
– vrms
Jan 24 at 14:21
thx for the pointer @Dave. adding quotes (of any type. tried "...", '...', ` ... `) result in the same error as before unfortunately. LIKE or RLIKE doesn't make adifference in that regards. Any other ideas?
– vrms
Jan 24 at 14:21
Please modify your question with the exact statement you are using now and the complete error you are getting.
– Dave
Jan 24 at 14:25
Please modify your question with the exact statement you are using now and the complete error you are getting.
– Dave
Jan 24 at 14:25
SELECT * FROM [table] WHERE code LIKE '%SI%' works though– vrms
Jan 24 at 14:31
SELECT * FROM [table] WHERE code LIKE '%SI%' works though– vrms
Jan 24 at 14:31
|
show 4 more comments
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%2f54347888%2ffilter-the-entries-shown-upon-select-in-mariadb%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
