SELECT *
FROM `eps_product`
WHERE (
(
`name` LIKE '%3419%'
OR `desc` LIKE '%3419%'
)
AND (
`name` LIKE '%显示器'
OR `desc` LIKE '%显示器%'
)
)
LIMIT 0 , 30
mysql 多条件模糊查询
最新推荐文章于 2024-06-30 07:27:16 发布
SELECT *
FROM `eps_product`
WHERE (
(
`name` LIKE '%3419%'
OR `desc` LIKE '%3419%'
)
AND (
`name` LIKE '%显示器'
OR `desc` LIKE '%显示器%'
)
)
LIMIT 0 , 30