/----------------------\
| TYPE | STYPE | OTHER |
\----------------------/

##</code><code>##

/----------------------\
| TYPE | STYPE | OTHER |
|----------------------|
| AAA  | BBB   | X=CCC |
\----------------------/

##</code><code>##

select * from targettablename where type='AAA' and stype='BBB' and x='CCC';

##</code><code>##

/-----------------------------\
| TYPE  | STYPE | OTHER       |
|-----------------------------|
| AA|BB | BB%   | X=CC%&Y=DDD |
|-----------------------------|
| AA|BB |       | X=CC%&Y=DDD |
|-----------------------------|
| AA    | BB%   | X=CC%&Y=DD% |
\-----------------------------/

##</code><code>##

select * from targettablename where type in ('AA','BB') and stype like 'BB%' and X like 'CC%' and y='DDD';
select * from targettablename where type in ('AA','BB') and X like 'CC%' and y='DDD';
select * from targettablename where type = 'AA' and stype like 'BB%' and X like 'CC%' and y like 'DD%';