MySQL Forums
Forum List  »  General

select query
Posted by: Dah Chang
Date: February 15, 2012 04:11PM

Table t has column name colors varchar();
colors must be in of list of ('red', 'green', 'blue')

select * from t where colors='black';
return empty

Is there any way to issue warning or error 'black' is not in the list?

dah

Options: ReplyQuote


Subject
Written By
Posted
select query
February 15, 2012 04:11PM
February 16, 2012 10:19PM
February 17, 2012 10:48AM
February 18, 2012 06:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.