SELECT si.user_id FROM ecs_store_info AS si WHERE si.store_name like (SELECT wl.store_name FROM ecs_wpaqq_log AS wl WHERE wl.lngShopId=0)
就是如何在like关键后使用select语句
...全文
16311打赏收藏
这个sql语句该怎么修改下?
SELECT si.user_id FROM ecs_store_info AS si WHERE si.store_name like (SELECT wl.store_name FROM ecs_wpaqq_log AS wl WHERE wl.lngShopId=0)就是如何在like关键后使用select语句
引用楼主 helloqhq 的回复:
SQL code
SELECT si.user_id FROM ecs_store_info AS si WHERE si.store_name like (SELECT wl.store_name FROM ecs_wpaqq_log AS wl WHERE wl.lngShopId=0)
就是如何在like关键后使用select语句
[Quote=引用楼主 helloqhq 的回复:]
SQL code
SELECT si.user_id FROM ecs_store_info AS si WHERE si.store_name like (SELECT wl.store_name FROM ecs_wpaqq_log AS wl WHERE wl.lngShopId=0)
就是如何在like关键后使用select语句
[/Quote]
SELECT si.user_id FROM ecs_store_info AS si WHERE si.store_name in (SELECT wl.store_name FROM ecs_wpaqq_log AS wl WHERE wl.lngShopId=0)
[/Quote]我是想用like做模糊匹配,不要精确匹配