instr()
有时,想要在字符串中查找某字符串可以使用instr()函数
instr()返回子字符串在字符串中首次出现的位置;如果没有找到,则返回0
用法:
INSTR(str,substr)
str:从哪个字符串中搜索
substr:要搜索的子字符串
instr()函数不区分大小写
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABScAAADRCAIAAACxXZAkAAAgAElEQVR4nOzdfXwU1b0/8O+EhDygoiKt7ZViSZbSNLZXXxXpbgsqVcn6QLzUVO+rEkW6uRppUoTb0qJWRVFBumvE3qSIqK0PqC2o7AasD9AmF7DVe68hpexG5acVFFEMeX6Y8/vjzM7Ow5nd2SSbnU0+7xcvXpvZM7Pf8zBn58yZmZV6e3spoXDwiU/Pu/a8SeqCPU+sOzC9gi85uueJx47OWup1qe/m5OT09fUl/D/x5wIAAAAAAABkMin+qDscXPfifs3fkz1Lrz2Pv9zzxLrGI8aFKgy5AQAAAAAAABKMugcHc90AAAAAAAAARJSVio1iyA0AAAAAAABAKRp125nrTsXnAgAAAAAAADgK5roBAAAAAAAAUgVz3QAAqdK5Z0+n1Xt7/C17RigMSZJG6JMAAAAAwCQ7FRvFXDcAABHRB0+/ce+9lu+eOaXzvAUFIxgOAAAAAIy8lIy68QxzAABu8s//WGz8aUUios7nf7qPZmHIDQAAADDq4b5uAAAAAAAAgFRJPNcdDq57cT9N9lRce94k8XtERDMuX+p1RRcnNdf91G1U/z4RkfQduugDWnEnvf8SLXxe9znSFHr1TqI36YLa6BKiux4lDxGRdXoiImqsp5X/rSx8bCb97sv0ow9N6Yl+vJquOT1BUUQCnjXTG+tKEyTTZir2Ed+hV78di98QpCFOvnz19fSyNrA36YJa41paoUrJW+/2hxuriywTrCq2ftuGSMDjqmkiongf41QJy8dg9fW0Q20bHyp1p63Hi5fQCoq9FrQrU7slTf3Gb7fWWdD87QuyulK+kGdMrSBy+1ljNREFPBJfQD6fr7m4rrE6libG7Q83Vof1W49uwSDg8dBjjdVFSZfnaG+fe1quvPfImT+a8+sFhjeO3HvlTvEqZ5750L/Y2k4k4KmgRlF1WHn//y5f+FYzEUlf3fDq7Ln2VwQAAACA4dcb16E/P3Lvln29+7Y88udDgrfu3bLPYkXGWPz/uf/3Ilv8ovL6L3XsglsFy9khtvhWdQ32lzr25CFmYJX+L3XsgrpYmvOvY/f8LZb4L3Xsnr8xxtiTtwq2qRMMBhkL+92+IGNhv88fjpta2eZf1D8OscV1gvzq8q6JUymHQ2zxdbHlf6lji7XbFPG73TZCG6rwyHxMCiQX+N80jYoxpmkn/+9FpeXwZNq6E7ZDq3qP087jMJd/0Od2u31BzdvmlEEfkduvXRj0EV9HTWVILygsdR2mW9Gm0d0+36spe73mOcPCjudq9u22/NP+dvQFry4T1RFj7OCyC7YqjfIvO8+85yAjooTxAwAAAECKJLjCfNJ512rmsDWO7gkemL5U/N4gn2Hu8Qkm+lbfRnQ6/TbuBKBl+sO0iehVn/LWlMvotUdpxTk05TL67WW6ta65M+FE9xavJLlqmuq9kuTaXHyp3Wm091+iH79EdDr91md8y3MF0YfROD/QxXnXGbT6TSIi+g79+ANqjOblQjsfGQ54JM4TiCjLItFlsUWKUKWaOFCpTaC+IXkCAY9pPbLYjOkj1Ggkj8fjCSRcLvYmXXC98u/HL+neeeo2ZfmFt9GPb0uwGSJx+Yh9Wamgp26LfehXEl0QwcVpt7F6t5fepvJy8laG4iQorWN87rqoutEwD2xaQERUutxPLWHDwsCqel+Z/mIP++VpnT7j26dq6hkJk3R88M/YH/98/o0rrxQ8ydy0ndLl/uZVhjBK6xgr3+wyF1vje/t/PEfpUDzfWvHOe6/YiR0AAAAAUmSw93V/epQmHX1iHffEnqO6N+1fXj7lMrpwb2zUpBV5ni64nl62HZEg/YdEXx5k/oxK68J+N7n9fncS166uvN54CbHWUw/TtG8TEb3/V6KZurc836Z3ogOza8po00vU+IKSOJGmGu/mcj77FS7f7FLGYUXVjYyxsN9tSB3weCkYTVwTu/w3VClF32Dh8s3G65EFytR5uNinEkUCnmg0LFjSpG7Gankcqx6l1x6l1x6lC/dGT0kQvf8SvTpTWX7XGdSaeDPi8rH0ARHRe0TT9iovPNF3dtRGTwTUUqGmmSVst2q920xv16V1QVplGH0VVTeWb3apw82ktheoqCkxDLAp1NJkGHQnWZ6jt30SUcFUKpgiGHUfuffKnVcq//a9P5V+d7P658619I0//nEy7Um8naLpJU2bzScXqht5Scat32M29gwAAAAASJlBPsP86KdHj+w/MtlTsfS8SXR0zxPBPeddG3tKb1L3dV9zJ11DRETvv0QX3hab7i5aQL+9jFbbmb0cVPpkbdtcEmysLo2QpyJQbe8Gy1WP0ldeIsP8ZeR5uuB5Ih7wOTa2cg5Nq6Vbp9CrPnpqS+LkvmD0pEBR9WN+z5oQlVrdiB4JbCZ/Y6maeHOF8kZoS7OfKW9QUXUjS5hd14FVkterxhB9UVS9skRySTXR0KIbslpu6cu06XpaGf3r4uiLKZfRtOuV8uS3+ieURPmcTtOI6E16ZyZduJeeOqx78+IltIJX35v0Y83ctVU7tKr3YWy3pcvLV1UEqh/TLVRrLxLwSB4S3qqt1VSj1IvbH240lEzkQDNRmX5ZEuWZbPoMap9ERDS55o+Thct1zzD/58GDVPDrGm3KgvN0jzi32E5psdvbEiYyn/Irqm5k1ZGAR5JqMvGBCwAAAACj3hCeYT7ZozxfbdJ50+mAdrp7cM8wn3IZXfQ+NeoXroh7ze37L8WmPQXpv0y0N7k8xVHNH6NWVJ3UM43MV7MXLaDXHqXXllDr80pmp3zbGGfjX2maZvp0xRK6y+61x+5i4UX/NhRNLxnkmhSqdKlTg4YZy9LoLc+MBckbm46zWi62egVduFqZ035c/7CqFdE58FeX0K2Jx67Jlc+ZRKv/StO+TN+dSa++QO8kvnw4GpWpvsz1Hj/9YBRVP1a+uXKb1ZsrfU0tieaio/cJB31NNWsSJk6+vY3O9pmMf5l6NbX4zdeUD0kk4HFtLmeMRYfcze99rnn75MLh/TgAAAAASMogR92TzrvWQ41B5a7P8FGarn3Auf37uldfr5lCPEzvfCd2Ba/WU7cJBipxKOlPp+vO0N0GvPp64yg9bc6hxxbQrfyJ0afTdWfQhdGnR7//Et36QXQeNZpYWCwiTTUV0RFCRHSNsFZRdTnFrlkNrFKfX11aVlKjuVU0VClJ8S4djhxodpcrR/uRQIXmel/jDbcl0+MvFztM70yJ3nh/mO7UXLT/1G36KejEo+JkyoeIiN75gGafQ1O+TfTfSd+wIGi32nq3kz5JRdUrqUatgFCl9o7fyIFm4z3Z1krrwv5m443igoFvnPLk91IbNpH57VOYLVv+efCn/iNEdN5VZx68943n1bu79xyxNQYPtTSJzllEAh5Jcm0u117F4PnWCjr2Ln/d+L+rp52JZ5gDAAAApFX8Z5jv23KvziN/Fr5pfpQ5s/cM83uuY+dH/11wXewB0edfp/t3wXXsL4yxvxmXq88kF6dnjDH25K26xJx2FW3i4aJ+qJoppolffVT7k7fGXv+lTv/uIbZYuwXNn1bRBn1E5Pb51Kk83eOr9TTPu1ZTu3VPftbOCEZTW25HuxkeQPTh2KIPtV5uRa2vC65j99TFqlJbuQnr0bp8LGmfLf/krcrzxtVg7vlbrE4Xv5i43RrqPX67tc6CseTUheo0NSnPMDckj+VXP99rqt7oI9D97thrdYlaW4nKk28uVrmjo33yXNh/RHrHczX7fv3r18vKXi+ree8DdfEH/EHlHYyx3b9O+FRzJQ/6uojmVxzMk1vPPH/TmedvOvOCnX9iDM8wBwAAAEgnqbe313ikOmRJ3dcNDhEJeCr4DzEDWAlVSlvKmJ3frB9uDmmfAY+0uTyJe6eP+K9sOfijc3+9oMD83h7/znt3EhGdaZFAY4gFL0kSY2yQKwMAAADA0KRk1E02Bt6p+FAYhIBHUi65dfsTPmoLIODxjOTg11ntMxLwuFpWjvxZh0jAU0FJPVHCAKNuAAAAgDTCXDcAwCiHUTcAAABAGg3hGebWMOQGAAAAAAAAoBSNuu0/wxwAAFINE90AAAAAaYS5bgAAAAAAAIBUwVw3AAAAAAAAQKpgrhsAAAAAAAAgVTDXDQAAAAAAAJAqmOsGAAAAAAAASBXMdQMAAAAAAACkCua6AQAAAAAAAFIFc90AAAAAAAAAqYK5bgAAAAAAAIBUwVw3AAAAAAAAQKpgrhsAAAAAAAAgVTDXDQAAAAAAAJAqmOsGAAAAAAAASBXMdQMAAAAAAACkCua6AQAAAAAAAFIFc90AAAAAAAAAqYK5bgAAAAAAAIBUwVw3AAAAAAAAQKpgrhsAAAAAAAAgVTDXDQAAAAAAAJAqmOsGAAAAAAAASBXMdQMAAAAAAACkCua6AQAAAAAAAFJF6u7uTncMAAAAAAAAAKNT9uHDh9vb2zs6Onp7e+MnZYzl5uZOmDDhxBNP/Pu7Hza/++Hho21EJEmSNo1hCQAAAAAAAMCYlZ2Tk9Pd3f2lL30pNzeXj5nj6O3t/fjjj0855ZTmdz+8et73TjvlpISrAAAAAAAAAIxZ2Tk5ObIsFxQUMEZElkNoxogxmY/Mc3JyPvr0+GmnTuwekJlMshxbi7/CTDcAAAAAAAAAEWVnZWVJCmKMJEni09c5OTlZWVmyLPPnjUsSDQxIkiSNGzdu3LhxPDGTqX9AHsB0NwAAgDP0yFmUJRERycz8IjdLTmdwAAAAY1K2+ooPtgcGZCLKzs4moptvvvnBBx/kU9mMMSKmu56csX5ZHhiQ+2WMugEAAJwhK2v+pZdOO+tff33PKu2LWaVlK25a3N+PUTcAAMBIy9b+IcuMiGVnZ48blzVr1qwf/vCHRMSY8g2tniuP4rPdTLa+Lh0AAABGEiM2tfisf/VcaHjxrW9+k+ErGwAAIB2UUTdjyp3bOTk548aNO/fcc8866yyXy6WmY4yYLNO4LP0SxvjQGwAAAByAMfnUyad/4ZSTDC8mTTyB8VPlAAAAMLKUUffAQP/AwIAsy9nZORdddNHpp5/+rW99a+LEif39/T09vcQvLmfyuOzY3HhPX9+nx7s7e/t7+gfSEzsAAADosfG5/MWHbV3mF1JvT3rCAgAAGMN093Uzxvr6eoPB4IoVK0499dT8/HzGmCxHrzCX2Tj9fd0DsiwPyAO4SQwAAMAZpGzlm5rJghcyvrIBAABGnG7ULcusq6snN5fdc8/q3/3uidzcXMaUp6zxF7qnlTMmy2xAlmUZc90AAACOkCXLk7805eQT8pn+xQl5uQxf2QAAAOlgvK+biHV3dzHG/v3ff/T22/8ry4w/TS066tb9NDeTZXlggD/2HAAAANJPZl+desYpJxTI+hcnFOTJMsNXNgAAwMhTRt2yPNDf3z8wIBMxIurq6srNlUtKzurt7VF/OYw/OU1dc2BgoKOnt727lw3gxDkAAIAjdMjsa9OLiKito0P7op+oo6NjfH9fugMEAAAYc9RRN+vr6yeSGUnEGBF1dnZq0ymT3Jq57v6+/s+Pd/T39ak3fgMAAEC6dR1vb+OvzC+60xMSAADAmJadlZVVUFDQ39+Xm5tLFG/8zJ+sNm7cuKysrDO+eOr7hz+ZdnJeb/84GXPdAAAAAAAAACLZWVlZJ510Unt7e29vLxFJkqR/ZppOVlZWfn6+JEnnfO3MPS2tHxz+aARDBQAAAAAAAMgw0scff5zuGAAAAAAAAABGp+zx48enOwYAAAAAAACA0Skr3QEAAAAAAAAAjFoYdQMAAAAAAACkSrxnp6XF/Q88nO4QLP3nLTelOwQAAAAAAADIJNnpDkDAmYNbJ58OAAAAAAAAAGdSRt0YUtqBUjJz5ikSAAAAAAAAh4jNdd9SU5nGOFQP+OvSHYIlRxWRE4JxcmUBAAAAAAA4ge4K887OznTFkRGcUD4FBQXq6/TGo40EAAAAAAAAhPAMcwAAAAAAAIBUiY26mTPEjTZUKVWGNH9HAh7d30SRgEey4AlEhlhY6S4bhXOCGWJ5AgAAAAAAjHq6ue4hjcB2VF/0cGtKB3KRwKpm//LSRFly+8N8U2G/W/talyhUKUmSYcSe0NBzN3TOiSe5sgMAAAAAABiTEo26d9ScXLMj9vqih98xJ+Cu2rR3xTkna6jrDdNYLrSmpmRldZF2PttV01TvNc5lN9W41He1r6PbiQQ8krSKfG7LT7IiLpx3Hr4omuOamlj2L3r4nVjhxdKcrEsxtPIRvP3OwxfFyl33h8COmkGFIIgEAAAAAAAAhHRXmMsmO7btq2BrTuHKN9EbvzjnlKiLH26VZZkxqnjmqMkzFSTaXmJWgUYCqyhYV0qRgKeCHlMGfmG/2xeMjgIbq4uIKPFcd1F1I2ONy4uTLyxjrIwRY7LM6Ny7/3r0mQpipQ/wvJ9791+PNlROnfvAM6xcKSY69+6/mkpoEOXDNFeYC9/XljsjxlofvviUmh2ipK3hfYMKwRgJAAAAAAAAWNE9w9w4jnrnv9a2zF8f+o8HHrBYm895PvbDSY8J3lxYOpzjsjU1TfUk1ZPbH268dJtHis1dS/VEROQLsrpSIj7XXaOuF3vt9g81Bm1+/rT0tKsfJ6LHJrWce+4bb3x7EhEtLH35pz+ldV5GTBmTzn1gb7j0wZcrb2ZEpB+nsliq4Yjnnf8qnXnglk9uZhSbiJYZMXZmZWjvf5VO+in7ZN33o0FrfHvSL2N/LHz6k3XfH0JAAAAAAAAAoBdn1P1OXdVKmr/nq6z1v7znrXzDsOLCp488MNf0UvXKLZODplH8UNQxtjwQCFdXlxJRdSOrFicr0rzFp8WjU+DDQJufuQ8c2TPde96BW45URbw3z98TLFo/ORiJ/J2KmJKUp/1qZfABYu9EtMu0GxyuUfdXK29ZOPmB//LO1yyPRvLVyuARIsbY3AeOHImeQXmnznvzga9/fXrVA5XTxJsEAAAAAACAoYqNuvv7+9va2tQ/D266ceUbdM68jra2qdc83XqNeVWeuqOPHr968uPmt+maOdrtDVWAT2/X1BD5guHiVZobtYmIT3W7Ah7jYtLOe2smxAdFn5+DL/3hDXrz6p9MvXVggDraOvqor6enaOoX3t7XXHTmafq0HT0Db9x13uSVus2dc+t1yZfQhAkT+AtDfRGde92tA8u27iPqefCSq+96M7o4Wjfn3Prqs9dNjca+6aoLI1Wtq84/uOmqSx5cG3tjMJEAAAAAAACAFd1ct6y5rfqd8PQNG6avf1eW5Xc3lX//7rcMK169IXzXHCJiTH2ptfNW15+YbH2bdtJ009uRwCrd+DkS8Kwh3UR3JOCpaCmhZiopKV5eN0zT3br8HHwlzM6mq6vmhhc/9SZdWEhEV18dfvrpu54iIip8KlosO28tf3fxGmJn//JPVa3f/9P3w4vfLV9OazZ/dUP5u/LQSsiw9pSFzzxzcFP5hqkLnwkvJCLaeatrfeGfNqtDalmWiQ5uKv/+3fTLDb/cf8MPNv5p83XP3L+pvLCQfqlJBwAAAAAAAMPE8hnms++8czYxIsbYVyqeOWBy52zlSdaMnl7sMln8NLFB/bJVvGCjDy+v3JYwUQU91ri8mKh4+XKqGMSPhAlp43zvtUihdzoxmn3DL88++5cvHzhw4MCdd9554MCBl3959g83qCW08+V/eM//ylcqnnmm4ivEzi6cypTrvmff+UzFV4ZWPqY3d678/t1vqeX+3rv/oLeCr72nedvlci2n+w8ceKZidsUzL3uDyze9x6v3flrucrnKN71n2uagagoAAAAAAACISDvXzZhpblom/ozrXbfP8D1jWPGH9fvvmE1E371j//47LDY+nHPdlZJU7/aHGSsiokjAU+NVnqKm8AWJQpWSN5aI+A+J8QnwUKUkeU3XoXul+mSuOtfm511WOPvM1rsjsiwzIpJfv/WH7y16auFU2rXh7reoXn791hmvzN2/6L31dONTU/iKu15+ZvrcO5T0gy0bpn+GueadXbfP+E1h/S/OfkXZ9q4Nd0+v3174mw2vX3vHbCKK1VXs/Rv3K7FNufap/dca82gzEgAAAAAAALCSlTgJEdHZv9i+X6P+h8ryXbfPuH0X7br9mscP0sHHr5kxY8Y1jx8kIqKDj18TfTks6ljst8GIiGK/GMbU3wUrNSaKKa1jjDFWV6r8cpjG4G70nr1wofaC7J2vPPPWPZfcvmvX7a8U/uJsIiI6u3Dqro2h0kV8xEsHH//NgV9E/1CWXHP7rsF8tsiu231U/1Qspl23+w78YtHsqQtvJJ/mU3bdPuP2XbxuZt+xf+4r0fradfuMYa0uAAAAAAAAILI96n7rnktmaCgz37tu91H9HdGB5NSFT+3fv/+phVPp4OPXXLNzzlP30s9TNJIrqm7UjZWNf6tLh/EB5pYOtr711j2tc/fv3/6LA75X5t4Ru8V95yt0Ix8H77p9xiWh0nsXpu7O6dl37Fdrgg4+fo06Bp99Rz35Zty+S10cS0az79j/1MKpBx+/5pr3Fu2/l34+Y/jOAgAAAAAAAADFeZoaEf9JaSbLMmNnr2j4/bVfUd/486+KX2Gy/L3bW75Lsix/ZRr5Lplxj2bN8rqWKTL96Pe/H97LzNNMXD7fvb2l5XainbcVR/6j5VfflYm5nvHNeObsFQ23X/sjkmX5z78qrqS6lt9/j29gylTXW5W8uMrrWoZSPIJ1GaNnfDOeKa9r+dV3o29/9/aWul8Vz7itruVXv28hkmWKRcCdvaJhijzlR/zdUVNdAAAAAAAA6Sfxu3Pvf+Dhm2+87uDB9F9j/GLwtf+85aZ0RyFw/wMPX+69IN1R0NSpUx/6zSYiSnt98UicWVkAAAAAAAAOEfdpaqDnhPKxfppa2iIBAAAAAAAAK3GvMAc9p5WP0+IBAAAAAAAAA91cN2Yv43NC+WjnutMbjxNKAwAAAAAAwOEw150Ep5WP0+IBAAAAAAAAA+m+tevTHYORMx/Qdf8DD6c7BAAAAAAAAMgwEq4TBgAAAAAAAEiRrHQHAAAAAAAAADBqYdQNAAAAAAAAkCoYdQMAAAAAAACkCkbdAAAAAAAAAKmSnTBFa2tr7r8UjkAog9Dzz9bCQofGBmatrWOovsZUZpOCkhkiFGDqoGztQ1mpMrEoMjFmO5yfL+dHaICAnWBUZsqmzMp7/Ggx1w0AAAAAAACQKhh1AwAAAAAAAKQKRt0AAAAAAAAAqYJRNwAAAAAAAECqJDPqbvXPz3dvaDUt3145ZY7/veGLaVAifrdUGRIudvsjSW0qVCnaEjieRRsAGBK0q/QJVSbdfw8Xq++ONIbkWCirQYr43ZIkOap7GZbuzoH50rTGwRwWjoiM3F+sgnZgG7DftjMoU1zKmo5jd5YEHFtTmOsGAIDUClVKUQ78GgRIh4h/4U/PCjLG6krTHcqwGq35AvtGZRsYlZkalZxcU8mMugtrtnY1Lc6Yh7cTEVFRTRNrqilKdxgAmWTszO6OnZwajGDGQ5WS5KUgU5RtcWfEmXN8d9iHshqU8N//+ztfd6U7Chr23sAx+bKA5pp6jmkDw9m2HZOpEZSZO4uTayq7u6cvYaIDnXHf7iGS6d1O6h2uoGybShSNv69vgPr7+rp7hr7V/n6Se3v6uoe+JTCx094GaxjbwPBIZWZTKuUl6ZiSsZNTx7UrGoYCHLFMNVR56xdt7Q1cGP2sCx969ULb8ffJNDDQM7K9cYLY0hGSY6GsVIPYJXsHaKC/L42doejwaRh6BsfkS89JrdH5ERpY12Z/P7G+XmODcUwbGFzbdnimzMQBjyZJFbuDayqpue53/UsmVe5V/gitmyTN5f9+WD+08IZRQ1Xe+Py88fl546u2ExFR64Nz8m7abnx3dm3tTfmzH2w1rTWnVj8J0/rgHMMGiVprZ+crC5Utm5dAYoKyjdTOHl+13VSJlssTbbyqgYhM9Rupna2p6O3alpAyKcisqNUJW7Ig+8r2lYwbEjRU5RX/517aOH98mkpGmBE7S5LdN805jW1TvC/Ha1d8yeza2pvEnUmq6MPQ9nia1/pysJnxhqq82bXblQqq2k603Zw1cyHoG9j2FzbOXLv0kgSR60tbs3z+Bsucppr4u8MQkkG8VppMwVp3AoL9xdzqRryLS66srMIzlt72Kl0xKvnl6UXtXNPIx+fz/dRid0ixOM0gduyxvWp82SO0d3lxft5NtebIBR116qI1d/jCL6DMypcx5lhrVFqCuR3eVDXyxwbi/UXYAzgiYPFXavAmTRU7pw3YbdsZlSm7ARsymy/sCa26bjUXxsQJv31Sy9zJm5c4qqbMR+BZLBHRVkLrJnnpGfbKUfbKUba6IuVRx6ENdOP8rVd09XR29XRuuWHj/Bu3K4sZMcZYqCrvCtrS09nV09n1CHt2Q3TVUFXeFc337+vs6uns6nn95kLNKuEHH2CPGDYYCSxa/o0tfGHX+ouFS8CCpr5EZcssK9FyufADGm7M/8ZzC5p7Oh+6hLFQVd49X2vmtbNvwbPFVQ2FN//ihr3PboswxhjbvnXDol8smZZxmRW0OnNOmbB5x7a/c8k0wVqXPNS1776ZtGgLTzDyJWOOWbjElNmk901DTnWf0rmFleXFasRGu+IJd//n3y/v7OrpbF5Dyxc9GElB8ekKME73xWKvjeVgN+NEu//zbvaIUjvj87eqWXsgWlOCQtA3MKbtpDWsPlTbUfdsWUSajlr0WcNN+50i+u7QhhQvR+Z2m0zBWnUC4p7E1OpGvotLqqyE4Qnqt/Brs/b+PcwYYw1bm2fOav5HmKef+YPSaaJ2Pu3mndGivoFmrnn7oUuYcHdIbVGIm4H52OPih3q2LKKZ9+/r7Fp/syhyw36UsphNHb647WVcvlic1kjESNAO1z800juO9f4iqAUHBCz6StX2PzMfuefBiHPagL22nWGZshtw3C8gc68Yf2dhtr99UpBzTZ7iSA8AACAASURBVN7Nnbx5iYNqSnSEZmuuW1ldjh4/vfzHbd9eVz5XWXxu6Y8tjkJSzhDnoi0PX8xfXbL0vpmPvKA9rb39hY0z1/xUmXIpWvKLG7TLH1kivGuhaMn6n1DtnIL83IKyR5RlhdNL6JGy/Dm16hkS8xJITFS2RGRdifEqV+uFmwrKaEvXziX8AQTbX9hIu39WkluQn1uQ/42f7aXmAxG65IpFe58PthJRwwsbb7hCPBE3jFKQWXOrE+bUonnHti9ca+SISsYcs3CJOewh7puGTzGUvJ12RUQ0676l84iICr0LZg6iQJIUr/vSiF8O8TI+676NPykkokuuWBTL2vQS2veP1niNJ9bAbEaufqiuo6aLr9B01OlqqFYhiZLFa7f2C5aIxJ2AVU9ianUj3cVF2Swrc3ii+i30Lpi58YUdRDte2Ldg44qS54KtFPlH86wF3rgNvvXB88toy86fpOcRNBbNQHDsYWaKPPF+lBqCtpeJ+UrYGs3tcIR3nLgRCmoh7QGLv0psfOs5uW1nXKZsBhz/kMYgcddt+9tnBJg7+fjdflq7IMMRGp5hbq31wfPzc2+gR5SzR8rSeQ919XR2PUKLcguURm9eAomIy3YYbGzeN1Nz5EpENHPN28pJwZ7Orp7XlxQRzfvp/fR8MNJau3rjoitSvu+lJLOiVifIqQ2DW2tYDKVkRNU63PvmrK9FC8Neu3KsZMshlvEEEhZC7KBwyB+aSQVuxXbBCiWxv4xsF5c0UXjm+i30Lpi57x+tDS80L/AWFn2Nng9uDz5PC7zxxtMNN5c8v6A5PQf0Q5O5kcfn5HyZ22HG7TgjHPDgvlKd3AYoAzM16AObIXwBpeygPXnmko9fF85qfrauMGdM+ae8nlvm/evSZ/7EF0aeW/tbbZqR/Efay3GINr6gXHQYefD6n+294fKLWSzNxVcs2rv818rVe5Haex4RLW+ofTASWyWyf+/MNRtuLmSMRbY9u1dZ+GDtdsZY4c2v77tv5u5/RERLwEKsvoRlG7cSRcvNm6dFv3j9tbcXPF+SezOvU139su1VN/GX00oX0HPrfv2cfN9PL0lJVlOdWXOrE+bUonnH9htx+ejTDLcEJWOOOcGSaNiD2Tc1Ob34ikV7l9+gXiC1fd3PaEHpNJZMuyIiOXZZVuz1MIsVoLh+3+Y5jddr2c24MDvR17YazyU198k/K/lerVr42286P1qDgg+11VHHduRhZ/hOMX20JiQDi1Y6mIK16gQsexLB1ka0i0u2rMzhieu3sHSB/PyiuzeWTJ/GX9/zLC3wTlM+0dTOWaR2znza8vrNsasGhcmGX7xdMk6ZkHqlpzDyFHbCzFR90b8s2l4m5ssywlgE5t1kRHecuBEKDwPSHLD4q0TUmzmkDdhp2xmXKZsBx/sCMvWKCXeWZL59Uph3QcmblzimpkRHaIOb6y796dM/Dl6dddHkrIsmL6T5Px7URobfInphQkHehIK8b/7srD92rtef2Lik9u01zWV5EwryJhRcTwtuEC1/YfoSzVn0i5feR8u/WZA3oSBv8T/OUk7tFC6Z/gJP/I2flWytvVi0BBISli0RWVdi3MrVK1zyWudWKsubUFC1Q1e/eS9eEV2xcMmKkkc20lWlI3AZYioyK2h1wpxaN2+FcK3C0gUzN5blTTg/xZduiEvGHHP8JdGwB7NvanN6SW3n1pKffYNvc0IZ/fF1fXnZaVcjzVQyhUs23Ec/OytRr5VUxm19umUhFC7Z1bHlLB7ShIK8CS9c8RqvQfGHXlK75YaNCTrqES5wq5BMycytdJAFSyTsBKx7EoGR7OJibJaVOTxx/RZ6r6K9exddcUn0dXSmW9TOd9z8jZ/tpein5024ebt4d0it+J2VuEwEkY8oY4cv+gLKxHzZaI3m3WREd5x4EYoPA9IbcPKHu+luAzbadsZlym7AFl9A4l4x0c6S1LdPyphLPn5dpLv5CY7ApfaOrvgrHT70z3dO/eqIxJe0aZ++e/qX/mUwa+6oOmH1jP99LYljIBi6w4f+Gbe+Wh+6oOQfK7pMnYjV8iHZsST/3q81v3pzqpqAozLrKIlKBhJAAaaOM8p2eDqBdHdxCaQ6vJGURFE45thjmJt6BuWrtfbCb+7/eYcyjjW3QwfsOPF6AEcG7CwZF7AdI5opx+zOXGZVaNxoW7PV6fZ4HPjrgVG24icial1/4a+nv/rQRUREO35y5cZz7317mu2VYbjELXL1WhY7y3f85ISyRzV/X/+HzgftH6S21q7euGhFe2qbgFMy6zxp2vNGTzGi60ode2Wb0rZk1TkkI/1dnEpUVoUjEd5Iss6Ic489htjCMjRf7wSf2ztzAf+9B8Fu4ogdx7oHcGjAjpNxAdsxcplSL9Eeoc9LzEmxJGYdLcu2tf64TMqthcKq337twhMK/o2IiM699+3RcYp9DLv4wfbOBwe15stLCv7tUbr+D50XDXNIqTP4zIIGihGGi6PbksO6OGNZvbyk4EQHhZdqo/XYIwPztePmE/9tI9GiP7QvmSbaTRy24xhlXMAAYCC1He+In+Ljjw615p85MtEkq7DrvS988UvpjgLs+vijQ2OnvsZUZpOCkhkiFGDqoGztQ1mpMrEoMjFmO5yfL+dHaICAnWBUZsqmzMp7/GhtXWEuZzl3rjuzrjqAMVVfYyqzSUHJDBEKMHVQtvahrFSZWBSZGLMdzs+X8yM0QMBOMCozZVNm5T1OtPi9bgAAAAAAAIBUkSKRSLpjAAAAAAAAABidpPe7Esza9/yztbDQoQ/J+PzzzydOnJjuKMCuMVVfYyqzSUHJDBEKMHVQtvahrFSZWBSZGLMdzs+X8yM0QMBOMCozZVNm5T1+tLjCHAAAAAAAACBVMOoGAAAAAAAASBWMugEAAAAAAABSBaPuIYsEPJIngGfSAQAAAAAAgEls1D0lX0pjHEMXqpQsCQfFoUqpMiTaUiTg0a9gWqD7LFdNEzXVuDRLxJsFAAAAAACAMUc31z2iA+9IwGM1So0EPNqRcpyUer4gEwj73dpEloNtVbiFymmNMlwPVEqSq6aJD6s1Y2/NZ4X9bv0n15UmUxAAAIOmngMUnBrUd3WClLrukPe06t+CLcSSaT7MfgCQmWKnmcd8fWZeq7bYPTOe8/Pl/AgNELATjMpM2ZRZeR9ktMYrzEdq4B2qrKDHooPWZq/2WywSqNhMbjspByESWFXvK4s3Ko4EVjWXX1pdx8J+t7v80uo6xsJ+t9sfZkGfIQuxye56b9xpdQCAFIgEPN5mf5gxxoIlNS7ePUYCHklaRT53wpRaoUpXTUmQnzQUbiG6HV3/bD8AyEyhSmlVcRhnlDOyVSfc6zOU8/Pl/AgNELATjMpM2ZRZeR9CtK8cZfyfcOErR1kkEhHNIA8jZVCr/SPoo9gii5SMsWPHjqmvDWNiHXWlxImCPuVV0MfjEKUK+izmuoM+Udig0NbXqDemMpsUlMwQxQow7HfHuiLdH8Y/LVJGuzK139MybFBZpOuf7QeQIdA49YzfuVpjsqzErdqhRRFv93RqzHY4P1/Oj9AAATvBqMyUTZmV9yFEK36a2txJI3mPd7ilqWR6ERHxeZTyx6qLEqcU0WZbN/5trC4ifm6iPpZGP3TmiSKBVfVERBSq9NLK6qLSOqVI+Vy32x9uVIKLzW5r57q99U01Lsx3A8BICLc0xS7dKZpeQs0HLPqeeCmVs7aNlh1vLKGxf7YfAGSiyLbN6v1WuJIr44zW3dP5+XJ+hAYI2AlGZaZsyqy8DyFay2eYj9jAO1TpbfYvLyUiigQqakpWWh76aVIm5iqmlrB+9TU1JcEEV8iFqTzodxOFDzRTvVeSPJWVHvW+bm99k7pJ7el/01x34qNXAIChihxoHnrKeq+rhvzW5zpj2zD3z/YDgIwUbmlqqmkpU77oqKYC4+4MMlp3T+fny/kRGiBgJxiVmbIps/I+lGiz1LGj4Y0/fSILlw+vUKXkpWB0KrqipiRoNSrWprSimX/W32wtSVJlqLSO1ZHm4ePeet0KnkCEqLS62kVE5KpuZCzsd5eU1TVqL7LTRie6r9tbP3xlAwAQT9H0kqGn9AVZsKTGlWgeU9g/2w8AMpU7eqq7qHqlr2nzNgy7M8Zo3T2dny/nR2iAgJ1gVGbKpszK+1CiFc91/+kTedBbtI8PpKMj2ci2zU2kGb021bjUR4XqU1rS322lv8ear8uvGBdeYa4d0Les8VSGKNxCtMUjaZ5hrjy8lJ/mKK1TRuNhv5vPfYf9bmqqWePsZwAAwCgSu7ApcqCZ4t2BY52ytC7sp/gPBLHun+0HABnHVZxJzw4Ds9G6ezo/X86P0AABO8GozJRNmZX3wUabxRjxf6qXj8jqwpRNdUcCHmlVcVgzkC6qbtSNiN3+sPo0XX1Km0rLSqLXw0UCnqSeh1e8fCV5JW9z+fK6RqZ7oExdqXKr26VFREWXllONS3LVNPlKWlySxB+2Ppaf8goAI6h0uZ+i5/lCa2rI+g6cBCmLqhuDvnqv9W8iWfTP9gOATFR0aTnFvkZX1bvLL3X2kRBojdbd0/n5cn6EBgjYCUZlpmzKrLwPJdqXj8j8n+FP9V9KnmFufDa48SmpsWfkxk1peIa5L8h/mzuaJux3E/mCFo9hNT5NTaGZwI7OnuvXD/vd5PNrPki5r5tHimeYx+G45xCm0pjKbFJQMkOkK0DeUxGR/omaWsobgpSGXjDoU7owiy1o0ul+dsJmAJkAjdMk9h1sqMcxVlbxWrVzi0K013POjdkO5+fL+REaIGAnGJWZsimz8j7YaKUdnw7w9S4+dZz6Wmvap+8WFhaalzvB559/PnHiRCIiigQ8rpomt/FBvHwx+YKsjioT3Xbt9ocbqyngqWgpofrm8nDj9DWmVdx+f8lmWq4+Fd1V00REvujl76FKyd7TgMckTX2NfmMqs0lByQwRCjB1ULb2oaxUmVgUmRizHc7Pl/MjNEDATjAqM2VTZuU9frTSjg8FI22taZ0ZMeqGDDCm6mtMZTYpKJkhQgGmDsrWPpSVKhOLIhNjtsP5+XJ+hAYI2AlGZaZsyqy8x482m41L7VPKAQAAAAAAAMasbOpPdwgAAAAAAAAAo1S2nIW5bgAAAAAAAICUEP9eNwAAAAAAAAAMnRSJRBImOu2000YgFAAAAAAAAIBRRmIswRXmra2teIY5DIsxVV9jKrNJQckMEQowdVC29qGsVJlYFJkYsx3Oz5fzIzRAwE4wKjNlU2blPX60uMIcAAAAAAAAIFUw6gYAAAAAAABIFYy6AQAAAAAAAFIFo24AAAAAAACAVBl1o+5QpSRJkiRVhtRFkYBH+Sv6pognENGs4AmEAp44aSIBj2YFwYKIdvXKkP5vNWUsNE0GPIFIqFK/dYsPNec9ujXNS6tSivc+AAAAAAAADIs0jrrVIbB++Beq1C6KmMa+wnFnLNmq4jBjjLG6UtGQlsgXZAJhv1uzsW2bqfxSF5HbH7ZKE26hclqjBBSolCRXTVNTjUsXn/JR6nrRzQV9CcumdHn55gpjRnlcRZZZl7z1VO81vVRC0p1x8NaT5n3LYgUAp1P3bP0+rO9IrVLqTs/xvoT/relXjAksF2oDsIgKnExclcK2NJpZH3WkpVWLjpSEe6LmLd0EgVXKNLN1BKhPKexhHJatmJFvLcIyid9+nNdp2//qoVHZNTmjFgbJeq/U9Es2OtiMqNJB1lS6Rt2RgGdLmTIGrfcqJRwJeCRpFfk0o9ui6kb9uNe3sto47tQkszGgTRyacHBriH5Vc/ml1XUs7He7yy+trmMs7He7/WFdAMqw1lXTxP/mo3I+5CVeY66apnqvJHk8sUborW+qcfFB/JqQbrCsDuxjKkPaEgr61JMKmpeMNfIi055ECPvd+vMPjaJiBQBHiwQ83ma+YwdLalyaEbO+I7VIqRWqdNWUBBmrKyUKVVbQY9GuolnpoC0W8rX4ZpVThQk/CxzIqirNbWmUszjqSEurFh4pCffEaPqKzRSrLE2dhv3NXuccx9s9ArTu4syrO8rItxarIhW1H+d22sIWK1w4Krsmh9TC4MTZK3X9knUH6/CdWmsINdXV3Rv/XyQSYSkV9OknlcN+t3hG2vzGsWPHjNvSbCo6soyNMOMNyqMrKsNn/dS2Pk3Qp7wM+tz+sHmj+jlyzTaNWdUPjvVRJ8y8diNx8dV0RWP1KSlmqq/RbExlNikomSGKFaCuWzD0Efo/LVJGeyC1TzOL9l7ChbouTdt3WkXldGO3cQqrMvanoBLHQlnFch63VY9EUZgOH6KRGKtNk1C7jnF9p1Rf/CPAhJ2JqVgcka/0thZhU1EXJt9pj2CRCltsnGY8uromp9TCkOlrydQvxYjrz5k7tdYQair993WHttS7E0wtKwnX1JB/eanoLfWCBT5RHG/KX1s0uoGoMtkbWhOdmqbYDh8dvCsftio6We2lldVFpXVKsfO5brc/3FhN+isoorPU3nrSxRfaUk/1XskTCAU8lSHS3s3N7+GOzXS7apoM14RrLm1w+8OCYXTQx5dblKdua845Bw4AdoVbmnxl0T6xaHoJNR+w2JHjpVTO2lpc7xJuaSqZbnxHuJCImlrCyUQFztXUEk53COmnOepId6u2OFLS7ImRQMXm8sd0e3Hpcj/VVAQiyj7+mAMvaUtwBJio2G0fQI6stLYWYZlYF5SjOm1hi82AZjw8nFILQ6VrbIJ+KZZQOKxz6E6tNYSayko4pE9V0NGR8pYye1c3x6sH5YKFsN+tniCxs01XMRkOLCKBVc1ud3Sb+m1EF4SpPOh3E4UPNFO9V5I8lZUedWDtrW9qCZPhsm9SZsS1w+LG6iL+Yb4ga6x2aT5meknzgUhk2+YSdUQvnm1St1NaxwM1Dsq99TzqOuGZCv35JVxgDpBxIgeah56y3uuqIcsDmVClt9n0rRhb6Cp281thKHbG0n5U4CCiqhzrNEcdaWvVcY+UNLtnJFBRU2K6Aa+o+jE/8XvWxHfnpY29I0DLYk/2AHJkpae1CMvEvNDZnbawxTq3GQ8r59TCIAlaoLhfUhiGdc7eqbWGUlPpm+uODkzLttiZaY0EVtUn2NtCla6WEl9TjSvu9rRDU+Wuas1d0mEqX1lOROGA9kZr7UqegKuaD5Jd1Y2Mhf3ukrK6Ru3AmN8Wqa6wpUwZGvOsxrYTWLOZfxhFAhU1TfVePlNfeaCYNldU1JSo51Eosm2z6Y5u4wS17k4J67F0NDBd1jHRDZCJiqaXDD2lL8iCJTUuUS8QqpS8FDR0I7qFRdWNQZ/Slawq9vvcxa4kogIHEVXl2KY76khbq7Y+UtLuiZFARU1J0HSGPVQpRW8BDxevctRXvb0jQMtiT+4AcqSlp7UIy8S80NGdtrDFOrgZDyvH1MJgmRqbRb/EmYZ1zt6ptYZSU+m/wry0Luhr2rwtfgFHtm3WTOcL8O+fujI+172yRXgMSWR8hrn+Zue60lLtiJrPMvvcbnK7/dHV1CPQljWeyhCFW4i2eCTdo84qQ1Rap17ZXe/lz+MLVUYfo0bk9ocbq6cXl1/KD2uKqlf6yBfk0dRVTy9patK1U/OIms/qx6anrH8SLXqPf+RAs3IdmuC2KADIULELmyIHmkl42XfClKV1YT8ZHwjC+1Sm/8IULFQuyGGscXpLfXSr9qMC5xBW5ZhlPupIa6s2HCnp98TIts1N2l8waapxSZUh3VRSUfXKxEdaaZD4CDBusds6gEyL9LUWYZnoFjq20xa22ExoxsPGCbUwZNHGZtEvcdbDOufu1FqDrak0XWGu+VGvSGBVwkv449zSrSTY0uwPx44ES+tsXp9QWqZ9gqPpKXShygpavrKESlZO32IcxhcvX0leydtcvryukekuAo/GkeCXw0qrY9cAHWhWJxZCld568pWVGn59W3PqJ1QpuVpWGnIovAJdc1N3uIXG/NQFwChTutxPmmsF4/SSCVJGpz80DxNeVRzWD7mFC2NiF7vajwocSXhbwVhjbLlpadXiIyXznqg7M688iqiulFzF7tjBa2hLvWMO4u0fAQqLPckDyDQY+dYiLJNEBeW4TlvYYh3bjIedQ2phcASNzaJfIiJz/py/U2sNpaY6Orvj/0vRM8w1A0Ldg+C0NMNW8W3N8Z9hrvmo2DPMfUH+KZpHlhP5grFRs+mRjsrT1LRPqVPS8C2pDzg1PYdTlxHtlLKakoemeR4wEY/Q7Q8a7+U2jd51+baqX0N0woRW94wPO8c9hzCVxlRmk4KSGSJdAcZ6GjsdqSGl4VcUgj5Sn0Jh6iGECzUbtej/Muj55YyN6cYprEqLtsQYG91lJTzqsG7VqSsKwZGSeE+M0T4AWFt/hqDTW31JHgEacyBaXeGUZjnirUVYJvHL2WanPZJFKmyxooWjtGtyRi0MTpy9kpmfnW/quDJgp9YabE1Re0dX/H8p/+WwIUg06o5+OykL9eNtlVJ2sR7e7Q9qhtiCX8EO+91un483GsE4VhmRxzbIR92xuW79qFv9O/ZG2O+O90M+pveEZxssfjtN+Khz0QcNPyfuOSkzpjKbFJTMEKEAUwdlax/KSpWJRZGJMdvh/Hw5P0IDBOwEozJTNmVW3uNHKx1v7zSNGnU+OvxhYWFh/DTp8vnnn0+cODHdUYBdY6q+xlRmk4KSGSIUYOqgbO1DWakysSgyMWY7nJ8v50dogICdYFRmyqbMynv8aNP/NDUAAAAAAACA0Sqbpe4XuQEAAAAAAADGNoy6AQAAAAAAAFIFV5gDAAAAAAAApIoUiST+JfLTTjttBEIBAAAAAAAAGGWkhFeYt7a2TpkyZWSiSVZXV1d+fn66owC7xlR9janMJgUlM0QowNRB2dqHslJlYlFkYsx2OD9fzo/QAAE7wajMlE2Zlff40eIKcwAAAAAAAIBUwagbAAAAAAAAIFUw6gYAAAAAAABIFYy6AQAAAAAAAFJl1I26G6pyc3Nzc3OrGtRFrbVzlL+ib4rMqW01bqu1do52O/o3rAhWaK2dI9i6LuboWpqXVrmL9z4AAAAAAAA4ShpH3eoQWDuMFC2MjXEtx66xJKtntPT09PT0rJ+nGW1rLN7aI9Cydpbh83Nzc3OLl+2mDfPFY+oE29EFF3yOfuAttAw5d/4G9WM0L5Xs6iKav4EMEcUdzgPAaKf2EPq+oKHKdA5QkFJ3mo/3SfxvTf9kTGC5UBuARVTgcIJmQ0RKLY+RujSfVY9mPE2t2va+LDowEB5oOdVguh3HZswxfWCsZWiKyiF7ur22bRmbMGtpFn8UY6oDTU6te56MNoixnoOq09ogd/B0jbpba+e8eHlPT09Pz9bFG+YrBSxc2FBVvKyED3G3lixbJM5d4ZKdynpDjmzW2hbReNo4pjaMxhXFy3Yr72u+AYuX7d69rFiXrqpBDZlHHR3Ea1729OxcUmiMqGXtLP14X0kDAGNQa+2c+c28g9hasqxYM2JeTYtnJUypFe1p188jaqhaRBujXU6z0hdbLBT0zwk/CxxI2Gyiby16jgTLRyfNdzP/1l+8Yklhmlp1cvty7FhBOTAQHlM5lqYzaVnbPJ8fy9pf6CiO6QMbqtS5KN65O2ZPT/Z7yhSbIGtpl2gUE2uugpxa9DwZLZmxnuAAw7EGv4Nndff0xf+XmogLl+xUdpJ5ly+m5nCr1cKGFzfMWrtUWbp0LT0XHFr3mmC0PG/9Ttc6UYrc3Nzcda6d6p6tHftuXawZGEdzsF6z55jmxdfPI83A3GKu2+GNDgDSrDX43O7oF/O8pWtnbXixgZTv7p1LZyROqWqoyp3fvLYl2r/NW6+eziv0/mAW74tFC4X9c4LPAmcSNRsi4ke7P9i4oiQNMaVda/C53Ysvn0fpatWD2JcNq5sPtJxs1gwXEREVukoGs9AxnNIHttaubl670TB0c8ienlzbNsUmzFraWe1xpuaaqIXEep7MZnusJz7qcKoh7ODpv6+74cUNs0zXXwsXEhHR7v1h80L1uoT5G6KzylYnPy1Hy2p9K+NlwXBZezJNO3qPfWr0o2Mz3YKr1GPxzVrbYpq8VsISXqtu+uTRcf0JAAxKeL/mi7nQVWJ9XB0vpXLW1uK6mfD+3SUu4zvChaT0z/ajAufjR7tOO7gdIQ3rlpFyVsk5rdo6kuiBiOCMvfUxlXPMW7qWli2qbVV6JN7o7C90Eoe0ltbgc/QDWmfvcNEJe7pVuZljSypr6aDZ40TNNUEL0fQ8o0UyYz2rAwzHGMIOnsUSSVXQ0ZHyi5drrpI2L3TNmLV72TrlAoR16gXcesp1GS1rZ6mXWNm58to1g0RjeB7FItq4lWIXORifrGY5eu/p2bmkMDZyt7pgfeeSwuiZHeOgfP4G0p4LMtIN0nGBOcCY1RpuHnrKDfOLl5HlcWtD1fxm05d/bKGof7YfFThea+2iZSWZf5njIGkOCZ3Tqq0iiV5fp7/mWnig5VSFSzaupWXFucXLdseurbW/0Dmc0lrC+3fvXrb/cqVZkNUtmkQO2dMtyk0UWxJZG1miPc7cXBO0kEw4SWaXzbGehvCow1GGsoOnb647egfD5S9qzlOZFxYu2bl1sTIuXT1j7eLodRpmDVXF+0sW715WHPe8l3aIW7xst27EW9XAW8Ii2tjTs2J/8XxaTPOrqqpylWXqMDi8n2a4Yjf+a+e6tR/dGnzOdEe3MY3uRg7rsXR08lwXsgNP7wHAiLF/cWWclIu39mwtWVYs6k0aqnLn01ZDd6RbKOqfnXnJJwxCa+2iZSVbHXLH5IhrrV29QR3SOadVJ4ykcMmKxbuj9+IJD7QcqqEqN3pnZ8uM1bnRW7jtLnQQ57QWUu8A0jULI4fs6cJys4zNXtZGmmCPEzTXuC1E1/NkPJtjvSjhUYfTDGUHT/8V5vPWbzXvL7qF6incna79GyyuOuAVtf5yPte9Yr/wGJLIMBSSXAAAG4ZJREFU+Oxx/Sz1+nm8JazYX8wfhr7+cqINdHnP1sWk/Vz1NIfx2nDDZeHmETWfjY9NK1n/lFl0Xr013Kx8tPlC9CRLGgBGndiFTa3hZop3VZZ1ynnrW9aS8YEgvE81PKRGsFDYP9uPCpyrNfjcbu0zR3YvKx5Djxsx31jpnFadfCTCAy1n0c7vqeMo+wudxgmtxTXD3pPRnLSnG8uNxLHZzVraxPY4q+Zq1UJGyy3dBonHehZHHQ412B08TVeYa37Uq7V2tdIihQs14lx10PCi5klARPPW27yYat7l2sfuRue6X7y8p6dnp2sdn73Z8GLDvPVbaX7shEx4v+CXwIRhVWlnpBuqcov3rzBEJrwCXTN6D+8ny9l9ABjT5i1dS5oLvOPcCJYgZXTOOvaIUX7eUZtIuDAm1j/bjwocTXfeeOtimrXWsvZHH2PLdU6rFkfSUBU9fGqomm/zmMpZXDNmxY6/G17cQCWuwiQWOopDWkuh9wcUO8S1bgGO2dMF5WYRm92sjSzhHidsrtYtZFR9ZyYx1ktwgOEsQ9jB0zTXXbhk44zV0WumS5SLCYQL9T/FbTWW1jz8Tvshwluj+QaVsfC8pcocT2vwOZrh4vv30nB07L1ziSv6AcoUeFVDa+3q6IyO8Y7sYsN95/PW9/T0bKRFavzm9iS6Aj22ndba1c3RvkR4+zcAjGGFSzaubeY9Q+yqLN7FxR7kWNVglVJr3vqerYs3zM+dU9vasG7Zbm3XNKe2Vblt27hQ3D8n/CxwIGGzGasEx/FpadX29+V56y9/UTk0UB+NKD6mcqroza/RjPWsn5fMQmdxSB9YuGTn1hJeUrEW4JA9fXDfUyph1tLNamgjaK4WOXXOGYRhYX+sJz7AcKzB7+BSe0dX/BSHD/1zypQpQwwwRbq6uvLz8zULGqrmhJfu1F7APX8DEc3iX0KttXOKl+2eZXxYL19Mi7f2rHepKVzrlGGtKXn0M1pr52h/SkzZ0iLaaFH+rbVzipeRfmuGeDVJ17l2rp8X+4iGqtwXL9d/tVis62Sm+hrNxlRmk4KSGSIUYOqgbO1DWakysSgyMWY7nJ8v50dogICdYFRmyqbMynv8aKXj7Z3x1//o8IeZM+oGRxtT9TWmMpsUlMwQoQBTB2VrH8pKlYlFkYkx2+H8fDk/QgME7ASjMlM2ZVbe40eb/qepAQAAAAAAAIxW2Sn8RW4AAAAAAACAsQ2jbgAAAAAAAIBUwRXmAAAAAAAAAKkiRSKRhIlOO+20EQgFAAAAAAAy2vjx4/v7+2VZFr4rSZJ6pa329dDl5OQwxvr7+9XXWVlZVpHk5OTIsjwwMDBcnz4U48aNy8rK6uvrG4HPMpR5woKKQ1uG8SvdzhaGt0YcVb9c4rbe2tpaWOjQn6f6/PPPJ06cmO4owK4xVV9jKrNJQckMEQowdVC29qGsVJlYFJkYsx3Oz5fzIzQYXMCMsc7Ozuzs7NzcXPNbkiT19/dnZ2drXw9TvPTRRx9NmDDhhBNOIKL29vbc3Nze3l6rSLq6urKysvLy8obr04eiv7+/q6vrxBNPNL81jM1GWObxCyr+1tQyjFPp9rdgrpFB5z0t9Rs/WlxhDgAAAAAAw6a3t1c4cytJUmdnZ3t7u+H1sGCMtbW18fEkY6y9vT0rK8sqEiLq6+sbmellOwYGBrq7u1P9KeYyt1NQcbS3t6trDX0Lw1sj2i07wbCdWwIAAAAAACAiSZKIiF9Uy1+rtBOtg57oNm95YGBAlmU+1zowMMAvnCYi/r+dDaoxGwLmS8zLrVYnU5bjr5LUW3aSaWMwp9GWubaghPGb/1RfS5I0adIk7caHvgXtKglXj8Nqy8mK0yqShVE3AAAAAAAMm5ycHH6jb19fHx/j5eTkENHAwEBWVpYkSb29vVlZWfx1Z2dnfn5+f3//uHHjGGMDAwOSJGVlZY0bN45vjTHW29s7MDCgbkqSJEmSBgYGent7x48fz1Py13xoxF8T0fjx43Nycvr6+gYGBngyHokZY6ynp0eSpHHjxvH/KTrWkmW5t7eX332dlZXV09OTn59vWFdNxkewPEir4LWfqM0pX8iLYmBggL8Q3ixtTmbIGmOsu7tbzQ7/dLX8Ozs78/Ly+BQ3LyirKiOinp6e7OxsvpBnk5eAtrKGZQsqnqa7u5tPVsdZnTeDnp4e9eP4/9otq2Vlbl1xthCnVQwORt0AAAAAADBssrKyPv/884GBAX5XLR/05uXl9fb29vb2dnV1jRs3bsKECX19ffx1Xl5ef39/W1tbX19fbm4uH5qOHz+eD7SOHTvW09OTl5fHR84dHR2nnHIKEXV2dvLXfEDV0dHBP46/Ligo0EaSm5ubnZ3Nh1jae335VGp/f/8nn3ySnZ2dk5OTnZ3NR2V8DN/T03P06NHc3Fy+hG/QMOrmefzkk09ycnJycnJyc3Pb2tpOOukkq+AZY319fUePHuWnDHJzc7Wzu319fWrpjR8/nl98br4/2ZCsv7+fv+ZjyyNHjqjZ4bnmN2+r5c8/1FxQhiojovb29oKCAnWGnNcULwF+7zQfpg59C9pKOXr0KEWn5YWr5+XlaWuHtxn+RDd+vYN2y1aty2oL/EyEsFUkdeO61qi5rztUKcXhCUR4Gk8gYpGWJzFtrzKkLooEPMpf8T7MsB39iqblsfUqQ/q/xdsRLNXFHP0czUur0or3PgAAAADA4PDZ3cmTJ0+cOJGPCTs6OogoPz+fj7EnT55cUFCgvuaz3319fZMnTz7llFMmTJiQk5PT1tZG0VHxKaeccvLJJ/OHjfX09PDpX0mS+AYZY3wcy0eS6mttJCeffDLfrOFOcj7z/Nlnn+Xn56vJsrOzjx8/zj/9008/PfHEEydNmnTyySebB9sqPhQ/7bTTJk6cmJ2d3dXV1dXVFSf4Y8eOnXDCCXyzhlG3tvTy8/PV0otTyPn5+Tk5OR0dHXw7x44d02YnJyeHZ0db/nwS2FxQhiobeqUnZfz48eqQe9KkSXHuDpAkiTF27NixCRMmTJo06aSTTuKFIHxSgLB1xdlCnFYx6Kfup3vUHQl4tANMzbhTNygMVRqXGJXWsZiw3+32hzULGquLeJrHqMITcNWxoI98QfXtoI98K6uLtJ+/qpivX1cqHjRr1tZ/sCbgKFdNU71X87dma8pm1PWiYQd9grLatpnKLy0SlSDnrafo52heSoJTDd56Il1IokE+ADifumfr92FBnylIqTs9x/sS/rewK06wUBuARVTgZAmqcqycqNWd/tYVR1patUX529vBHVx9osDER4DxUzq2h0lHaxEeKsdrKtrFwx8wYyw/P1+9WzgrK0v/G04vV0rS6tWrb71168tERNQefmXhwoVf+tKX+PTjqaeeuvf9noGBAfmA/9Yf/nDnzp3PPvvsH/YzIsrPz//iF7+Ytf1GSZJu+fMJfIhLRPyqZn4BMH/Nl8uyrI0kOztblmX+62JqqHwJf/K5mkySJD57zBibMGGCml54jTFjrLd3+/JTTuFl+3J2tjKWPrTtf3fufPbZZ3/+85/X/jUafNbf/vbcc1/84hdPOukWXgtZWVnjxn14yxe+IEnS5s2vbD8cKz3+icJfwNIWMt8Iv3yaLz/ppJP46ISI+BPjtbnmtAWVqMoSM26h40DpaadJkvTSS42hj9RUoQ3//u9PPPHE6acvNzTMjRs37tixo6FhX6SnR5blU089NeEN+ZIknXbaafx0Bs+sJEnCsHkz4HUnSRIvUl5cwi3EaRW9vS8Obn9J76g7EqjYTG71z1BlBT0WHb42ezVHf6vI57bcSjKKqhsbq4uISuuC5FVHo1vKWF2p8rbloDdZsXF52O/W/aFJpAx9XTVN/O+mGpckSXxYTES6wbKrpin6tuaLKRqycvIgaHoZPedA2hMRupA0aQAgg0QCHm8z37GDJTWuOH2mMKVWqNJVUxJkrK7Uoiu2WMjX4put4N8+CT8LHMiqKreUKd8p9d6xUZOa71T+ha2ekx/5Vi0sf/s7uGOrTxiY1RGgKKWgrTrKyLcWq1YhXChsVCkJ2DBkYrEZwk9/c8m2MsZWrFix8Nt/La95mYhOcM3dtGkTn0hkYf+58kLXtBOI3qicsfSTRc/OnTu39Gz5wIP3NR/t6e//rK70NEPWJEnq6uriFzNrX5sjkSSJiLQDM0mSZFnOysrSPmOMryLLMmOM384dJ6eMMcbaH/3By1fKslq2eXl548btuOmMK54dN7e0tHSFb3bR/lDzZ/2MtW5Z2vTlK6/88MMPg77fRmvh4+atof2r9jDGymdPfPJnm16xLL3EhcwY6+7u/vzzz49F8Qu/DaPu+AUV50Pj0Gzhf3ZveWPGk4cZY5edd9Jj60OtRLwFfvvJJ6+99tonr30i1i/t+Im0qviqRYsuu+yy73znjDMYy83NtfkMPH5reltb26effnrs2LH+/n6rsLWnS/jGeYEIt2DdKg4/OGf+IPeXru7e+P8ikQhLDT4jHfSRfl5a+6b2T8H08rFjx4RbFm4z6DPMUCtDa9GsddCnWT86Qo2NVOMNyvmKulGvcdQtnCePZti6PCzm1xOeIuCr6bJkGUVqWdXXqDSmMpsUlMwQxQpQ1y0Y+gj9nxYpox1V0EfCfocJrhzSLtR1V9GF8aJyurHbOIVVaZmAsbFRVrHmG7dVj0RRGMvf1g5uvbpjqk98yBO3BcZtq47IV9pai7C/te6E1ZJMQcCyLH/66afKEJoxxlhPT8/hw4f56+PHj3/22WfK6zd/RzPvCTMmy/KxY8f4KmG/27XydVmWDx167qdf9L74IWOM9fe/tIjOe+B/jnV2dh47dqy/f78aqizLsix/+OGH3d3dx48fV18z/WbV2A4dOtTd3c3famtrY4z19fWp4anJPv74487Ozr6+vo8++ki7vLe399ChQ4bE/f39hw8f5qN0FvTduOaVD2WZsT/95t9W+MOsv7+/o+OP/3Hi+fuO8OD7lU9Ua+GTvzwd2PHUxx8zxmS57emlV1z/h1jM7e3thvDiFzIPpr29vSOqu7u7o6ODjyd5+WsLLWGVffLJJ/zadcNb2jI0buGt327Y+r//rWzh+O+WLLn///RbePJacvs/l+Vjxw7ce955/rCytcOHD/M7z/mmeAuME8Ann3xy6NChY8eOdXR09PX1WcWmbQY874cOHeJX+1ttQdwq3nz4PFo0uP0lfXPdkUDF5vLHLGdYwy1NJdNtT78abrT21pN5Vri0jrGyLZInEFASK2f7yraoaQLRi5a89dH1rS4d0BaxbkCrThrHruDWXWGuTmsbLmOLzmRrYo+FylfTXxOuubTB7Q8LhtFBH19uUWa6rTn2Ii0AsBRuafKVlSp/FE0voeYDFjtyvJTKLIfF9S7Crtiqf25qCScTFThXU0tY93doS73bfIfTKBdaU0P+5aVE6W/VCco/UXiOrT6LwAQ9jHUWjG01/dLdWmyKFemIByxpfn4psv+tmWWX8JodP368LMt816v/yRxZlmX5O0vun8Ra32ntan1o9mX7/b9b+q2JeXl5six3dnYXzrnyu2coz6Du7++XJIk/mUx9TdHNqjPb6ojLfJU4f9oZaaaL+/r6+OO++VPf1LfUJ4qz6Jwqz1F+fj5P9trOUPn8mSd1dnZ2fudHa7wv+J9+d9y7v73oytb7Hvn6JB58pyRJubm5L/0hWgu9eR99/cy5SiwnfPEMagm/Yy46Znvymd+fXBCVk5PDi0WNVlto8TfFGMvJyWGmn/Kyj7GBL8048e8R3RZeDT3hLr/0RCL6uPmPdCWtkTZu3HjjjTfO33Q4JyeHz0WrxW4VgCzLfX19/F567ePWzKKtiyh6dQOfyo6/BUGr2Ne054b5g9tfsuKMyDmbG0pSJFBRU7LScswdqvQ2K991tuju6mZhv9t08pRfQV5axxqrq+vURaFKT8ClrltXza8s065v58prVzEJOv1EV5jrLw0nPu2vG82roQpnm6JpikrreJDGQbm3nn9KnbgcdYN0XGAOkHEiB5qHnrLe66ohv9UJUGFXHFvoKnY31axRrvpcw88o2o8KHERUlUSx08Nbysbe14RmnJe2Vm2v/C3Dc2z1xQ1M1+2YU1q1Vcdweh9oKtIRDpgxlp2dPb79zSunTLnpppt6v3v3a9Uz+FsDAwM5OTny3zuLfv/gtydTR0dHdnb2VxfedtJbD+97eV/HpS9u+kkhRX/JiYjOOPv8s07rb29v5z8xlZubK0nSuHHj1NfqZvmIiw9q2tvb1TuZVVlZWbm5uerFyYyxtrY29YnlRCTLMv8x8O7ubnUML0kSf4o4H5+P7/9w26OP3nXXXRNrDn5vWj6fZc37iuvhqwo237P52MUvbLpxmhL8O7+5xevdtWtX1i3dvBY+/fAAscQ3UWs/MU6yrKwsbZYZYx0dHZ2dnbHyHz+eiAwFFYf2em9eFAlXodPPmHzkjYdfJSKiN3/XMWXWVV/PIiI6/vdH77rrd7/7Xaj0sLJTHzm0Z8/PW8rYokWLfnPHVfTzykCE+KPg1cfRWQXAGJs4cSJ/LBwR8cePC3OktK5omfDWxW93t9qCsFX8v/f2U9YgfwIsPXPdkUBFTUnQYjRIoUrJS8HBf0NEtm0uCa5sWSO4zp4/GC02yxyb05Y0j/92tZT4mmpccWeAtUPcOE9Li0MzP7+lTBk+a2feYx8f2bbZdEe3cYJadyua9Vg6+qG6kDHRDZCJiqaXDD2lL8iCJTUuUS8g7Ip1C4uqG4M+pStZVez3uYtdSUQFDiKqSmU5Y4x/NY2tr4pIYFW9Lzo3kLZWba/8LcNzbPVZB2bsdswprdqqYzi9DzQVaSoC5oND9U/GmPonn2LtLvjXR99+OxAI9P3hqh/d/tL/HDvG03R3R154emv+mV/rOXq0o6Nj4sTdlVLF/5SuPf/882+8qv/J6+/8/T8+//jjjyVJKijI27/j9w3729vb2wcGBrq6uviDuPv7+9XX/OM6Ozu7u7vb2to6OjqOHj3a2dk5ceJEQ5B8RNfR0XH8+PH29vYjR450d3efojwaTcrNzW1vb//oo48++ugjWZa1I/b29vbOzk5lnFZw5vnl5dXV1Z9vmpvnuff9nJyCgp1VOf/23184/8Ybb7zlWlo196b73vhYkqSCklv827d///vfP+nVG67+5R//77PP+j/Yu+H1d9WYP3vvLW3paZ8Erv3EOIXMM97W1nb8+PGjR4+2t7fzsaVS/t3dHR0dbW1t2oKKszX+02VtbW2fffbZ0aNHtW8JXxMR++IlcwsPP/Hvp0uSlPWT/s/e+kPvuO62trbP+k+/7D/+4wc/+EFp6HTJE/inJPV90krn3bu8lCRJ6jvle8uv27N5W0SSJP676Py6AKsAsrKy+HKezSNHjvCfKzOXT19fn7YZdHR08GYQZwvCVnHON79FNs5TCKVl1B3ZtrlJ+7TtphqX9ievvBRkViNyGxsPVGwuX15aurx4lWn0G9m2mYpdmhGq9trwulL14+vK+Fz3yhbhsSiR8W5w/U3TPPhEV5iX1qnT3vVePlQPVcYeo+aOXfFpHlHz2fjY9JT1T5lFyyByoFm5XktwuxcAZKjYhU2RA80U77Yc65SldWE/GR8IIuyKBQvVC40ap7f8//buJ7RtK44DuCz/lRTZcxMZfOgOy6Ub3amjTdvDDrvsMuhpO20wGGZs7Lpryw6Dwihll9HS8w6BjXYlaelhg8ACXW/t2A5xWGlIqDDZcJY6TZRUPTxZf5+f5NpPeYq/H3IIsvz8ez89P+tZ8nvX+6UmjwrEQT2U3oOLreX5BYHGbZy1F+Z9N91K0iG36vj8M8MT9vCFAmOcAQb2ZLZVIWShDwyklEPAuq77R3SlUoksXi1JElkKi6x+fParz1/77sq9J844trh25/I3pebJF+Vy2TCM8q8L5JYTXdeV4++fzF36/uY/1WrVMIx8Pm/+9cfKVoWMnRRFIbOC7e7uuv8T1WpV13UyCbmiKI1Gww1M0zR3z0qlUqvVyCJkmqY1Gg331utCoTA9Pd1sNpvNpqZp+/v77nVXVVXr9TpZEbpSqei6LsvyqS++/OT+7eX/pnN3b10/9+H5E7qiKC9m3n3v9R9uLXVI8OS5pz/7SPn28p0nhWP57Ue//d1xUtRu3197+6033ezJsuxmz/+KjCSXy2Uyu7tt22SdMHfNM5L/g4MDf/XZpamqSp5eKBTq9bqqqu5D/kLCJZz/utfrkbfq7xdL0vFACReu3Wwtz//UlrQ3mnO5oltaqf+dRrFY1HXdzRU1AFmWa7UayQZpM1NTU2Q59FBspEBVVclq3oZhkFDZJVBaRTE/Z2+tOUWubdlzH5xO/H551nvO/uM3m5o76OuPWGl3hjsSzqYWLCE4FrZjf+ncWuw/I342tVAwXi3IXoNnU/Nt8LY7/3kvGwx9sSX55jqKTAtHqWnkhZ09opEPei4PQkxzkpaJquxQkJkR+RLo6xjZky0N2DO47kFgKcNIt8Don0OlMqISHRqnHf04s51/BZ2Oi49Iy2W1al6pYOU/wRtc2MNHD4zWwzCrYNM6GDGa5WG0ltDrDto4OPmpBkwLg8zF9fOn0ZY+6Px3uImWXw359e/e3h658Zj8BnhjY6Pb7SapFD1+QY5CiuI+Vlg9wVjqHp0rbgQrf96+sfTYsizLerx045eH/1oe/8R7USKNusMXXb0GGxwae88NHAn/SWPfytVzvm20wTL9jJC6PTTqJoH5zzOl1iL1J9jhUbd/qt9AvfwZoJ7z0h9hXa92p1915/6Mwqibh4mq7FCQmREFEuj1IoEZaCl9JmXPUJ/Y/3qP2hXH9c+R86Roh50BE9w46YfS15jCh/Io52rg905pp4KW/yHe4MIePkpg9B4mJgPRsxdRmmXarYXaKuhNhd4qUm/e1DDMB1fOSGei372EW3vyocE4kOmvTdPsdDqmaa6vr29ubjpzlSeoFC1+UY4CZ0N9rHhdQKjy46q7aZpjGnXb9srVd5xgP/7xacDq6irjedL2sx32H+9R9yjcI8FY98Ybjg9xnTe0vd8UAp8Cgz6SKWeZkcvr4S+iY651RwujXcSn7hp7lR7XujmZqMoOBZkZERLID3KbHHLlymIqshhzEuLXS/wIQ9IMeGdnx7KsEQvhFDD5LfRYInwFmWs2YzSuuqdz7NjR5v7f7klM5tON2dlZ9j6Hpdvtkp9zQCZM1PGaqMoOBZkZERLID3KbHHLlymIqshhzEuLXS/wIQxCwCI5kpRLKVt3Z0R7eet0AAAAAAAAAR13B5rUiNwAAAAAAAMCkw6gbAAAAAAAAgBfcYQ4AAAAAAADAS67dbsfuNDMzk0IoAAAAAAAAAEdMDneYAwAAAAAAAHCCO8wBAAAAAAAAeMGoGwAAAAAAAICXlwLzat9+nai2AAAAAElFTkSuQmCC)
instr()函数与like运算符
在没有索引的情况下,instr()函数与like运算符的速度是一样的;在具有前缀搜索的LIKE运算符下,使用like运算符速度会更快一些
concat()
使用方法:
CONCAT(str1,str2,…)
返回结果为连接参数产生的字符串。如有任何一个参数为NULL ,则返回值为 NULL。
注意:
如果所有参数均为非二进制字符串,则结果为非二进制字符串。
如果自变量中含有任一二进制字符串,则结果为一个二进制字符串。
一个数字参数被转化为与之相等的二进制字符串格式;若要避免这种情况,可使用显式类型 cast, 例如:
SELECT CONCAT(CAST(int_col AS CHAR), char_col)
MySQL的concat函数可以连接一个或者多个字符串
mysql> select concat('11','22','33'); //112233
MySQL的concat函数在连接字符串的时候,只要其中一个是NULL,那么将返回NULL
mysql> select concat('11','22',null); //NULL
concat_ws()
CONCAT_WS(separator,str1,str2,...)
CONCAT_WS() 代表 CONCAT With Separator ,是CONCAT()的特殊形式。第一个参数是其它参数的分隔符。分隔符的位置放在要连接的两个字符串之间。分隔符可以是一个字符串,也可以是其它参数。
注意:
如果分隔符为 NULL,则结果为 NULL。函数会忽略任何分隔符参数后的 NULL 值。
concat_ws(',','11','22','33') //11,22,33
和MySQL中concat函数不同的是, concat_ws函数在执行的时候,不会因为NULL值而返回NULL
concat_ws(',','11','22',NULL) //11,22
转载自:https://blog.csdn.net/huihuikuaipao_/article/details/86598471
https://blog.csdn.net/weixin_36207483/article/details/113442921