Include and Exclude

[Face]

Hi,

 

I've got a column (serialcat) in table (serial) which contains a combination of characters - axzyodu.

 

These characters could be in any order for each row. What I want to do is to display all rows that contain 'o' or 'd' but not 'y' in the serialcat column.

 

So I'd expect back examples of :

axdo

xuod

zoda

oax

xdu

etc.....

 

Any help appreciated.

 

Thanks.

[fenway]

You can use regular expressions to accomplish your task:

 

SELECT serialcat FROM serial WHERE serialcat REGEXP '[od]' AND serialcat NOT REGEXP 'y'

 

Hope that helps.