摘要:
查询表字段 pingid = (1,2,3,)SELECT * FROM `linkinfo` WHERE `pingid` REGEXP '{id},' AND `pingid` NOT REGEXP '[[:alnum:]]+{id},' 使用上面的语句,可以查询出来用FIND_IN_SET() 更简单SELECT * FROM linkinfo WHERE FIND_IN_SET( '1', pingid ) 原来以为mysql可以进行这样的查询select id, list, name from table where 'daod 阅读全文