| "use strict";(self.webpackChunkdoris_website=self.webpackChunkdoris_website||[]).push([[51374],{15680:(e,n,r)=>{r.d(n,{xA:()=>u,yg:()=>y});var t=r(296540);function l(e,n,r){return n in e?Object.defineProperty(e,n,{value:r,enumerable:!0,configurable:!0,writable:!0}):e[n]=r,e}function s(e,n){var r=Object.keys(e);if(Object.getOwnPropertySymbols){var t=Object.getOwnPropertySymbols(e);n&&(t=t.filter((function(n){return Object.getOwnPropertyDescriptor(e,n).enumerable}))),r.push.apply(r,t)}return r}function a(e){for(var n=1;n<arguments.length;n++){var r=null!=arguments[n]?arguments[n]:{};n%2?s(Object(r),!0).forEach((function(n){l(e,n,r[n])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(r)):s(Object(r)).forEach((function(n){Object.defineProperty(e,n,Object.getOwnPropertyDescriptor(r,n))}))}return e}function i(e,n){if(null==e)return{};var r,t,l=function(e,n){if(null==e)return{};var r,t,l={},s=Object.keys(e);for(t=0;t<s.length;t++)r=s[t],n.indexOf(r)>=0||(l[r]=e[r]);return l}(e,n);if(Object.getOwnPropertySymbols){var s=Object.getOwnPropertySymbols(e);for(t=0;t<s.length;t++)r=s[t],n.indexOf(r)>=0||Object.prototype.propertyIsEnumerable.call(e,r)&&(l[r]=e[r])}return l}var o=t.createContext({}),c=function(e){var n=t.useContext(o),r=n;return e&&(r="function"==typeof e?e(n):a(a({},n),e)),r},u=function(e){var n=c(e.components);return t.createElement(o.Provider,{value:n},e.children)},p="mdxType",f={inlineCode:"code",wrapper:function(e){var n=e.children;return t.createElement(t.Fragment,{},n)}},d=t.forwardRef((function(e,n){var r=e.components,l=e.mdxType,s=e.originalType,o=e.parentName,u=i(e,["components","mdxType","originalType","parentName"]),p=c(r),d=l,y=p["".concat(o,".").concat(d)]||p[d]||f[d]||s;return r?t.createElement(y,a(a({ref:n},u),{},{components:r})):t.createElement(y,a({ref:n},u))}));function y(e,n){var r=arguments,l=n&&n.mdxType;if("string"==typeof e||l){var s=r.length,a=new Array(s);a[0]=d;var i={};for(var o in n)hasOwnProperty.call(n,o)&&(i[o]=n[o]);i.originalType=e,i[p]="string"==typeof e?e:l,a[1]=i;for(var c=2;c<s;c++)a[c]=r[c];return t.createElement.apply(null,a)}return t.createElement.apply(null,r)}d.displayName="MDXCreateElement"},519438:(e,n,r)=>{r.r(n),r.d(n,{assets:()=>o,contentTitle:()=>a,default:()=>f,frontMatter:()=>s,metadata:()=>i,toc:()=>c});var t=r(58168),l=(r(296540),r(15680));const s={title:"FIELD",language:"zh-CN"},a=void 0,i={unversionedId:"sql-manual/sql-functions/string-functions/field",id:"version-2.0/sql-manual/sql-functions/string-functions/field",title:"FIELD",description:"\x3c!--",source:"@site/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/string-functions/field.md",sourceDirName:"sql-manual/sql-functions/string-functions",slug:"/sql-manual/sql-functions/string-functions/field",permalink:"/zh-CN/docs/2.0/sql-manual/sql-functions/string-functions/field",draft:!1,tags:[],version:"2.0",frontMatter:{title:"FIELD",language:"zh-CN"},sidebar:"docs",previous:{title:"LOCATE",permalink:"/zh-CN/docs/2.0/sql-manual/sql-functions/string-functions/locate"},next:{title:"FIND_IN_SET",permalink:"/zh-CN/docs/2.0/sql-manual/sql-functions/string-functions/find-in-set"}},o={},c=[{value:"field",id:"field",level:2},{value:"description",id:"description",level:3},{value:"Syntax",id:"syntax",level:4},{value:"example",id:"example",level:3},{value:"keywords",id:"keywords",level:3}],u={toc:c},p="wrapper";function f(e){let{components:n,...r}=e;return(0,l.yg)(p,(0,t.A)({},u,r,{components:n,mdxType:"MDXLayout"}),(0,l.yg)("h2",{id:"field"},"field"),(0,l.yg)("version",{since:"dev"},(0,l.yg)("p",null,"field")),(0,l.yg)("h3",{id:"description"},"description"),(0,l.yg)("h4",{id:"syntax"},"Syntax"),(0,l.yg)("p",null,(0,l.yg)("inlineCode",{parentName:"p"},"field(Expr e, param1, param2, param3,.....)")),(0,l.yg)("p",null,"\u5728order by\u5b50\u53e5\u4e2d\uff0c\u53ef\u4ee5\u4f7f\u7528\u81ea\u5b9a\u4e49\u6392\u5e8f\uff0c\u53ef\u4ee5\u5c06expr\u4e2d\u7684\u6570\u636e\u6309\u7167\u6307\u5b9a\u7684param1\uff0c2\uff0c3\u987a\u5e8f\u6392\u5217\u3002\n\u4e0d\u5728param\u53c2\u6570\u4e2d\u7684\u6570\u636e\u4e0d\u4f1a\u53c2\u4e0e\u6392\u5e8f,\u5c06\u4f1a\u653e\u5728\u6700\u524d\u9762,\u53ef\u4ee5\u4f7f\u7528asc\uff0cdesc\u63a7\u5236\u6574\u4f53\u987a\u5e8f\u3002\n\u5982\u679c\u6709NULL\u503c\uff0c\u53ef\u4ee5\u4f7f\u7528nulls first\uff0cnulls last\u63a7\u5236null\u7684\u987a\u5e8f"),(0,l.yg)("h3",{id:"example"},"example"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre"},"\nmysql> select k1,k7 from baseall where k1 in (1,2,3) order by field(k1,2,1,3);\n+------+------------+\n| k1 | k7 |\n+------+------------+\n| 2 | wangyu14 |\n| 1 | wangjing04 |\n| 3 | yuanyuan06 |\n+------+------------+\n\nmysql> select class_name from class_test order by field(class_name,'Suzi','Ben','Henry');\n+------------+\n| class_name |\n+------------+\n| Suzi |\n| Suzi |\n| Ben |\n| Ben |\n| Henry |\n| Henry |\n+------------+\n\nmysql> select class_name from class_test order by field(class_name,'Suzi','Ben','Henry') desc;\n+------------+\n| class_name |\n+------------+\n| Henry |\n| Henry |\n| Ben |\n| Ben |\n| Suzi |\n| Suzi |\n+------------+\n\nmysql> select class_name from class_test order by field(class_name,'Suzi','Ben','Henry') nulls first;\n+------------+\n| class_name |\n+------------+\n| null |\n| Suzi |\n| Suzi |\n| Ben |\n| Ben |\n| Henry |\n| Henry |\n+------------+\n")),(0,l.yg)("h3",{id:"keywords"},"keywords"),(0,l.yg)("pre",null,(0,l.yg)("code",{parentName:"pre"},"field\n")))}f.isMDXComponent=!0}}]); |