Jump to content


Photo

Using LIKE multiple times on same field


  • Please log in to reply
1 reply to this topic

#1 Face

Face
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 22 November 2005 - 10:41 PM

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.

#2 Face

Face
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 22 November 2005 - 11:28 PM

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%'




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users