Jump to content

Archived

This topic is now archived and is closed to further replies.

Face

Using LIKE multiple times on same field

Recommended Posts

I've got a table with about 25,000 rows. I was selecting on the serial field using the following :

SELECT distinct(LEFT(serial,2)) as serial FROM aircraft

 

This would return the distinct first two characters of the serial.

 

What I'd now like to do is to just select serials that begin with X, W, and Y. But trying

SELECT distinct(LEFT(serial,2)) as serial FROM aircraft where serial like ('W%','X%','Z%')

or trying

SELECT distinct(LEFT(serial,2)) as serial FROM aircraft where serial like 'W%' and serial like 'X%' and serial like 'Y%'

 

don't work.

 

Does anyone have a solution ?

 

Thanks.

Share this post


Link to post
Share on other sites

Ok, just figured it out....

 

Use OR instead of AND :

 

SELECT distinct(LEFT(serial,2)) as serial FROM aircraft where serial like 'W%' or serial like 'X%' or serial like 'Y%'

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.