Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÖúÒ»ÌõSQL likeÓï¾ä! - .NET¼¼Êõ / ASP.NET

ÇóÖúÒ»ÌõSQL likeÓï¾ä!

table

ID name bran_id
1 ss 1,2
2 aa 10,13
3 cc 1,13,15


µ±bran_id like 1 µÄʱºò£¬½á¹ûÏÔʾµÄÊÇID=1ºÍµÈÓÚ3µÄ£¬¶ø2²»ÏÔʾÒòΪID=2µÄbran_id,ÊÇ10ºÍ13

ÇëÎÊÎÒÕâÌõSQLÓï¾ä¸ÃÔõôд£¿
×Ô¼º¶¥Ò»ÏÂ

bran_id like '%1,%' or '%,1,%' or '%,1%'

string strlike='1'

where ','+bran_id+',' like '%'+ strlike +'%'

string strlike='1'

where ','+bran_id+',' like '%,'+ strlike +',%'

SQL code:
select * from table where bran_id like '%1%'


bran_id like '%1,%' or '%,1,%'

ÒýÓÃ

bran_id like '%1,%' or '%,1,%'


bran_id like '1,%' or '%,1,%'

SQL code:

select * from table where '%ÄãµÄ×Ö·û´®+','%' like bran_id+','



ÒýÓÃ

×Ô¼º¶¥Ò»ÏÂ

ÎÒ¿´´íÁË£¬ËûÃǵĶÔ

select * from table where bran_id like '%1%'

ÒýÓÃ
ÒýÓà 6 Â¥ kkbac µÄ»Ø¸´:

bran_id like '%1,%' or '%,1,%'


bran_id like '1,%' or '%,1,%'


11

select * from [±íÃû]
where bran_id like '%1,%'
{


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......

ASP.NET¿Õ¼äÎÊÌ⣿ - .NET¼¼Êõ / ASP.NET

ÄÄÀïÓÐÃâ·ÑµÄASP.NET¿Õ¼ä£¿£¿Á·ÊÖÓÃµÄ Ð»Ð»

5944µÄ¿Õ¼äÊÇÆ­×Ó£¬×Ô¼ºËÑÒ»ÏÂÊÔÊÔ£¬Ãâ·ÑµÄÓУ¬Ò»°ã¶¼ÊÇÈýÌìÊÔÓã¬Ò»¹ýÄã¾ÍÒª½»·ÑÁË

ÒýÓÃ
5944µÄ¿Õ¼äÊÇÆ­×Ó£¬×Ô¼ºËÑÒ»ÏÂÊÔÊÔ£¬Ãâ·ÑµÄÓУ¬Ò»°ã¶¼ÊÇÈýÌìÊÔÓã¬Ò»¹ýÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ