下面这句应该怎么写:
SELECT *
FROM SearchSpecies
WHERE ([01] LIKE '10083%') AND ([01] LIKE '10012%' OR
[01] LIKE '10013%')
SELECT *
FROM SearchSpecies
WHERE ([01] LIKE '10083%') AND ([01] LIKE '10012%' OR
[01] LIKE '10013%')
FROM SearchSpecies
WHERE (字段名 LIKE '10083%') OR (字段名 LIKE '10012%' OR
字段名 LIKE '10013%')
FROM SearchSpecies
WHERE (字段名 LIKE '10083%') OR (字段名 LIKE '10012%') OR
(字段名 LIKE '10013%')
FROM SearchSpecies
WHERE ([01] LIKE '10083%') AND ([01] LIKE '10012%' OR [01] LIKE '10013%')或SELECT *
FROM SearchSpecies
WHERE ([01] LIKE '10083%') AND [01] LIKE '10012%') OR ([01] LIKE '10083%' AND [01] LIKE '10013%')
你理解错了.01必须包含 '10083%',在此基础上选01包含'10012%'或'10013%'的.也即三种情况
1. '10083%','10012%','10013%'
2. '10083%','10012%'
3. '10083%','10013%'
WHERE ([01] LIKE '%10083%') AND ([01] LIKE '%10012%' OR
[01] LIKE '%10013%')