MySQL - Order specific field values in multi columnHow to find all the tables in MySQL with specific column names in them?Multiple “order by” in LINQOrder a MySQL table by two columnsHow do I specify unique constraint for multiple columns in MySQL?SQL multiple column orderingmysql indexes of multiple columnWhat happens if I drop a MySQL column without dropping its index first?Update a column value, replacing part of a stringmysql count some column's values in one columnHow to find duplicate values in mysql table based on ANY y out of x columns where y<=x
Relations between homogeneous polynomials
Why is implicit conversion not ambiguous for non-primitive types?
Unfrosted light bulb
Should I be concerned about student access to a test bank?
What is it called when someone votes for an option that's not their first choice?
How to split IPA spelling into syllables
What is the purpose of using a decision tree?
Why didn't Voldemort know what Grindelwald looked like?
Offset in split text content
"Marked down as someone wanting to sell shares." What does that mean?
What is the meaning of "You've never met a graph you didn't like?"
A seasonal riddle
Why does a 97 / 92 key piano exist by Bosendorfer?
Not hide and seek
How do you say "Trust your struggle." in French?
Started in 1987 vs. Starting in 1987
Does capillary rise violate hydrostatic paradox?
Travelling in US for more than 90 days
Weird lines in Microsoft Word
Why doesn't Gödel's incompleteness theorem apply to false statements?
How can a new country break out from a developed country without war?
When is the exact date for EOL of Ubuntu 14.04 LTS?
Asserting that Atheism and Theism are both faith based positions
Amorphous proper classes in MK
MySQL - Order specific field values in multi column
How to find all the tables in MySQL with specific column names in them?Multiple “order by” in LINQOrder a MySQL table by two columnsHow do I specify unique constraint for multiple columns in MySQL?SQL multiple column orderingmysql indexes of multiple columnWhat happens if I drop a MySQL column without dropping its index first?Update a column value, replacing part of a stringmysql count some column's values in one columnHow to find duplicate values in mysql table based on ANY y out of x columns where y<=x
I have table like
+-----------+------------+------+------+------+
| id | name | col1 |col2 | col3 |
+-----------+------------+------+------+------+
I want order my table with two column like (col1, col2) in (v1,v1),(v2,v2)... and some other order.
In MySQL has ORDER BY FIELD(col1, 'v1', 'v2', 'v3') DESC, other columns ASC; but how using it in multi column like my example thanks.
mysql sql-order-by
edited Mar 7 at 1:08
Bill Karwin
383k64519676
asked Mar 7 at 1:06
DeLeDeLe
44742755
add a comment |
I have table like
+-----------+------------+------+------+------+
| id | name | col1 |col2 | col3 |
+-----------+------------+------+------+------+
I want order my table with two column like (col1, col2) in (v1,v1),(v2,v2)... and some other order.
In MySQL has ORDER BY FIELD(col1, 'v1', 'v2', 'v3') DESC, other columns ASC; but how using it in multi column like my example thanks.
mysql sql-order-by
edited Mar 7 at 1:08
Bill Karwin
383k64519676
asked Mar 7 at 1:06
DeLeDeLe
44742755
add a comment |
I have table like
+-----------+------------+------+------+------+
| id | name | col1 |col2 | col3 |
+-----------+------------+------+------+------+
I want order my table with two column like (col1, col2) in (v1,v1),(v2,v2)... and some other order.
In MySQL has ORDER BY FIELD(col1, 'v1', 'v2', 'v3') DESC, other columns ASC; but how using it in multi column like my example thanks.
mysql sql-order-by
edited Mar 7 at 1:08
Bill Karwin
383k64519676
asked Mar 7 at 1:06
DeLeDeLe
44742755
I have table like
+-----------+------------+------+------+------+
| id | name | col1 |col2 | col3 |
+-----------+------------+------+------+------+
I want order my table with two column like (col1, col2) in (v1,v1),(v2,v2)... and some other order.
In MySQL has ORDER BY FIELD(col1, 'v1', 'v2', 'v3') DESC, other columns ASC; but how using it in multi column like my example thanks.
mysql sql-order-by
mysql sql-order-by
edited Mar 7 at 1:08
Bill Karwin
383k64519676
asked Mar 7 at 1:06
DeLeDeLe
44742755
edited Mar 7 at 1:08
Bill Karwin
383k64519676
asked Mar 7 at 1:06
DeLeDeLe
44742755
edited Mar 7 at 1:08
Bill Karwin
383k64519676
edited Mar 7 at 1:08
Bill Karwin
383k64519676
edited Mar 7 at 1:08
Bill Karwin
383k64519676
383k64519676
asked Mar 7 at 1:06
DeLeDeLe
44742755
asked Mar 7 at 1:06
DeLeDeLe
44742755
asked Mar 7 at 1:06
DeLeDeLe
44742755
44742755
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You can concatenate the strings.
ORDER BY FIELD(CONCAT(col1, ',', col2), 'v1,v1', 'v2,v2', ...)
answered Mar 7 at 1:24
BarmarBarmar
433k36257359
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%2f55034554%2fmysql-order-specific-field-values-in-multi-column%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
You can concatenate the strings.
ORDER BY FIELD(CONCAT(col1, ',', col2), 'v1,v1', 'v2,v2', ...)
answered Mar 7 at 1:24
BarmarBarmar
433k36257359
add a comment |
You can concatenate the strings.
ORDER BY FIELD(CONCAT(col1, ',', col2), 'v1,v1', 'v2,v2', ...)
answered Mar 7 at 1:24
BarmarBarmar
433k36257359
add a comment |
You can concatenate the strings.
ORDER BY FIELD(CONCAT(col1, ',', col2), 'v1,v1', 'v2,v2', ...)
answered Mar 7 at 1:24
BarmarBarmar
433k36257359
You can concatenate the strings.
ORDER BY FIELD(CONCAT(col1, ',', col2), 'v1,v1', 'v2,v2', ...)
answered Mar 7 at 1:24
BarmarBarmar
433k36257359
answered Mar 7 at 1:24
BarmarBarmar
433k36257359
answered Mar 7 at 1:24
BarmarBarmar
433k36257359
answered Mar 7 at 1:24
BarmarBarmar
433k36257359
433k36257359
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%2f55034554%2fmysql-order-specific-field-values-in-multi-column%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
