SQL - LIKE function pull many item

[apple]

Hi all,

Can anyone let me know how to pull many item use LIKE % function?
Please refer my attachment. Thanks

[mattj]

Use the AND and OR comparison operators:

Like blah AND Like blahblah OR Like Blahblahblah

HTH
Matt

[apple]

Hi,

Could you please explain, i not understand. Thanks

[mattj]

Example:

SELECT "*" FROM Table WHERE Table.Column1 = 1 OR Table.Column1 = 2

SELECT "*" FROM Table WHERE Table.Column1 = 1 AND Table.Column2 = 2

[apple]

Hi,

If i put "OR" , "AND" is it LIKE function can pull 2 or more number than that, at the same time. As i know "LIKE only can pull 1 number right?

For example:

SELECT*
FROM TABLE1
WHERE COLUMNA LIKE '%A%' or '%B%'

Is it the example correct if i want to pull 2 item number at the same time

[mattj]

I really don't understand your question, so here are some more examples:
SELECT "*" FROM Table WHERE Table.Column1 Like 1 OR Table.Column1 Like 2

SELECT "*" FROM Table WHERE Table.Column1 Like 1 AND Table.Column2 Like 2

[apple]

Thanks for your help