select value in a table

HI all,

in my sql table I've a list of colors: white, blue, green.....
table colors
idcolor, coloname
1, white
2, blue
3, green.....

I've some programs sending colors for some material, but I don't want to use
them, I'd like to use my values:

example:
program gives 'dark blue' then I'd like to select blue in my table and
return 2...
how to do so ?

Thanks for replying.

Re: select value in a table

Maybe exploding by space a returned value would help in this case
Bob Bedford ra=9A :
> HI all,
>
> in my sql table I've a list of colors: white, blue, green.....
> table colors
> idcolor, coloname
> 1, white
> 2, blue
> 3, green.....
>
> I've some programs sending colors for some material, but I don't want to =
use
> them, I'd like to use my values:
>
> example:
> program gives 'dark blue' then I'd like to select blue in my table and
> return 2...
> how to do so ?
>
> Thanks for replying.