开发者

Selecting a specific column value in SQL

开发者 https://www.devze.com 2023-03-07 03:53 出处:网络
I have a column in a table with values like this: IDQuarter 1February-2009,March-2009,April-2009, If this is the value in the first row with a primary key id of 1, and suppose 开发者_运维知识库I w

I have a column in a table with values like this:

ID    Quarter
 1    February-2009,March-2009,April-2009,

If this is the value in the first row with a primary key id of 1, and suppose 开发者_运维知识库I want to select a single month, say for example I want april, then how to query the table to get the result as 4 (since I want to get april, it is 4th month).

Thanks, Shakul.

0

精彩评论

暂无评论...
验证码 换一张
取 消