gpt4 book ai didi

mysql - SELECT * FROM table_name WHERE column_name like %value% IN (SELECT ...?

转载 作者:搜寻专家 更新时间:2023-10-30 20:04:19 24 4
gpt4 key购买 nike

我需要一个类似这样的 mysql 查询:

SELECT * FROM table_name 
WHERE column_name like %value%
IN (SELECT * FROM table_name WHERE column_name like %second_value%)

我该怎么做?

谢谢!

最佳答案

由于我对您的问题的理解是正确的,您的查询必须是:

SELECT * FROM table_name 
WHERE column_name like '%value%' and column_name like '%second_value%'

关于mysql - SELECT * FROM table_name WHERE column_name like %value% IN (SELECT ...?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/31668323/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com