想表的所有字段中查詢一個(gè)值怎么寫?select * from bianhao where???
熱心網(wǎng)友
where 你設(shè)置的主鍵=主鍵值;這樣就可以了!如果沒(méi)主鍵,只要有一個(gè)你需要篩選的自己需要的條件即可!
熱心網(wǎng)友
如果是這樣數(shù)據(jù)庫(kù)的設(shè)計(jì)就有問(wèn)題.
熱心網(wǎng)友
WHERE (field1 LIKE '%value%')OR (field2 LIKE '%value%')OR (field3 LIKE '%value%')OR (field4 LIKE '%value%')OR (field5 LIKE '%value%')……