select value in a table

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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:

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š :
Quoted text here. Click to load it

Site Timeline