Face Posted November 22, 2005 Share Posted November 22, 2005 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. Quote Link to comment https://forums.phpfreaks.com/topic/2919-using-like-multiple-times-on-same-field/ Share on other sites More sharing options...
Face Posted November 22, 2005 Author Share Posted November 22, 2005 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%' Quote Link to comment https://forums.phpfreaks.com/topic/2919-using-like-multiple-times-on-same-field/#findComment-9788 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.