¡¡¡¡
±ÈÈç·µ»ØABCÖÐCµÄλÖÃÊÇ3
InStr([start, ]string1, string2[, compare])
Õâ¸öº¯ÊýÐèÒªµÄµÄ²ÎÊýÊÇÆðʼλÖá¢Ö÷Ìå×Ö·û´®¡¢Òª²éÕÒµÄ×Ö·û´®£»CompareÊÇ¿ÉÑ¡²ÎÊý¡£Ö¸¶¨×Ö·û´®±È½Ï¡£´Ëcompare²ÎÊýÊÇ¿ÉÒÔÊ¡ÂԵģ¬Ò²¿ÉÒÔÊÇ 0, 1»ò 2¡£Ö¸¶¨0£¨È±Ê¡£©×ö¶þ½øÖƱȽϡ£Ö¸¶¨1×ö²»Çø·Ö´óСдµÄÎı¾±È½Ï¡£ÀýÈçÎÒÃÇÒª²éÕÒÔÚ×Ö·û´®¡°abcdefg¡±ÖÐÊÇ·ñ´æÔÚ¡°cd¡±²¢·µ»ØÆäλÖã¬ÔòʹÓÃÏÂÃæµÄÓï¾ä¾Í¿ÉÒÔʵÏÖ£º
pos=InStr(1,"abcdefg","cd")
Ôòpos»á·µ»Ø3±íʾ²éÕÒµ½²¢ÇÒλÖÃΪµÚÈý¸ö×Ö·û¿ªÊ¼¡£Õâ¾ÍÊÇ
×Ö·û´®Ê¾ÀýÈçÏ£º
select * from xw where xwlb_id="&xwlb_id&" and InStr(1,"""&rsdy("hdgjz")&""",xwbt) order by px_id desc,id desc