Rookie's question again - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Rookie's question again

Rookie's question again# Database - 数据库

M*72008-10-31 07:10

1 楼

I am new to SQL.
Q1:
Here I have a column. Some rows containing the name like "c1", some others
like "b1*" or "h10$".
I just want to select the rows like "c1" but not those "b1*".
Q2:
To create a scalar UDF, how to return more than one return value?
Thanks a lot.

n*62008-10-31 07:10

2 楼

如果在sql server里面，可以用
SELECT * FROM Table1 WHERE Column1 like '[_]1'
[_]表示任意一个字符/数字。
不过你用“”表示字符串，可能你用oracle。我不知道oracle用什么表示。

【在 M***7 的大作中提到】

: I am new to SQL.
: Q1:
: Here I have a column. Some rows containing the name like "c1", some others
: like "b1*" or "h10$".
: I just want to select the rows like "c1" but not those "b1*".
: Q2:
: To create a scalar UDF, how to return more than one return value?
: Thanks a lot.

M*72008-10-31 07:10

3 楼

could I use "where column1 not like" ?

【在 n********6 的大作中提到】

: 如果在sql server里面，可以用
: SELECT * FROM Table1 WHERE Column1 like '[_]1'
: [_]表示任意一个字符/数字。
: 不过你用“”表示字符串，可能你用oracle。我不知道oracle用什么表示。

n*62008-10-31 07:10

4 楼

Yes.
Sorry I did not look at your question very carefully. In your case,
you want 'b1', not 'c1*'
You can use:
LIKE 'b1'
If you have other requirements, you can look at %, [], _, ...

【在 M***7 的大作中提到】

: could I use "where column1 not like" ?

M*72008-10-31 07:10

5 楼

sth like "where column not like '%*'.
this works but I am not sure whether it is correct

【在 n********6 的大作中提到】

: Yes.
: Sorry I did not look at your question very carefully. In your case,
: you want 'b1', not 'c1*'
: You can use:
: LIKE 'b1'
: If you have other requirements, you can look at %, [], _, ...

n*62008-10-31 07:10

6 楼

% represent unlimited characters for any values.

【在 M***7 的大作中提到】

: sth like "where column not like '%*'.
: this works but I am not sure whether it is correct