網上查了很多還是沒查到我要的 , 下面查一個可以執行

$sql_query = "SELECT * FROM user WHERE address LIKE '%ABC%' AND address1 LIKE '%ABC%'";
但我要查多個 , 查到最後只想到下面這樣但還是不行
$sql_query = "SELECT * FROM user WHERE address LIKE ('%ABC%','%DEF%','%GHI%') AND address1 LIKE ('%ABC%','%DEF%','%GHI%')";
SELECT * FROM user WHERE address LIKE '%ABC%'
UNION
SELECT * FROM user WHERE address LIKE '%DEF%'
UNION
SELECT * FROM user WHERE address LIKE '%GHI%'
再去篩 address1的條件
                        我是來請教方向與方法 , 知道方向方法比較重要 , 以後都用得上 , 只是要到了 code , 下次 code 又不一樣 , 那我不是也沒學到 , 難不成幾千條 code 都一個一個問 
"SELECT * FROM user WHERE address LIKE '%ABC%' 
UNION 
SELECT * FROM user WHERE address LIKE '%DEF%' 
UNION 
SELECT * FROM user WHERE address LIKE '%GHI%' 
SELECT * FROM user WHERE address1 LIKE '%ABC%' 
UNION 
SELECT * FROM user WHERE address1 LIKE '%DEF%' 
UNION 
SELECT * FROM user WHERE address1 LIKE '%GHI%'";
"SELECT * FROM user WHERE address LIKE '%ABC%' 
UNION 
SELECT * FROM user WHERE address LIKE '%DEF%' 
UNION 
SELECT * FROM user WHERE address LIKE '%GHI%' 
SELECT * FROM user WHERE address1 LIKE '%ABC%' 
UNION 
SELECT * FROM user WHERE address1 LIKE '%DEF%' 
UNION 
SELECT * FROM user WHERE address1 LIKE '%GHI%'";
                        謝謝各位 , 改成這樣可以了 
 $sql_query="SELECT *,MIN(time) FROM `fruit` WHERE time LIKE '0%' AND(afc LIKE '%芭樂%')AND (afc1 LIKE '%蘋果%' OR afc1 LIKE '%葡萄%' OR afc1 LIKE '%龍眼%')";
                            <p>dog830228 你是說這樣嗎 ? 不行執行 , 沒關係有 1=2 也沒差 , 請問如果要再加篩選條件 , 如 time LIKE '%9%' 要加在哪 , 我試過好幾個方法 , 下面是其中一個 , 還是不行</p>
<pre><code>SELECT * 
FROM user 
WHERE (1=2
	or address LIKE '%ABC%' or time LIKE '%9%'
	or address LIKE '%DEF%' or time LIKE '%9%'
	or address LIKE '%GHI%' or time LIKE '%9%'
AND (1=2
	or address1 LIKE '%ABC%' or time LIKE '%9%'
	or address1 LIKE '%DEF%' or time LIKE '%9%'
	or address1 LIKE '%GHI%' or time LIKE '%9%'
                        <textarea class="SimpleMDE form-control comment__textarea" rows="3" name="description" cols="50">dog830228 你是說這樣嗎 ? 不行執行 , 沒關係有 1=2 也沒差 , 請問如果要再加篩選條件 , 如 time LIKE '%9%' 要加在哪 , 我試過好幾個方法 , 下面是其中一個 , 還是不行
SELECT * 
FROM user 
WHERE (1=2
	or address LIKE '%ABC%' or time LIKE '%9%'
	or address LIKE '%DEF%' or time LIKE '%9%'
	or address LIKE '%GHI%' or time LIKE '%9%'
AND (1=2
	or address1 LIKE '%ABC%' or time LIKE '%9%'
	or address1 LIKE '%DEF%' or time LIKE '%9%'
	or address1 LIKE '%GHI%' or time LIKE '%9%'
                        <textarea class="SimpleMDE form-control comment__textarea" rows="3" name="description" cols="50">[alex9453](/users/20104326)
1=2是我寫程式的習慣用法..哈(用在多重搜尋條件0.0)
正確是跟[dog830228](/users/20096630)一樣的~
WHERE ( address LIKE '%ABC%' or time LIKE '%8%' 
WHERE ( address1 LIKE '%ABC%' or time LIKE '%8%'
WHERE ( address LIKE '%ABC%' or time LIKE '%8%' 
WHERE ( address1 LIKE '%ABC%' or time LIKE '%8%'
                        謝謝各位 , 研究語法後 , 改成這樣可以了
$sql_query="SELECT *,MIN(time) FROM `fruit` WHERE time LIKE '0%' AND(afc LIKE '%芭樂%')AND (afc1 LIKE '%蘋果%' OR afc1 LIKE '%葡萄%' OR afc1 LIKE '%龍眼%')";