avatar
a*s
2
What part do you want to ignore? In mysql, if I define a field like char(5),
the case are ignored. select * from table01 where name ="a"; is the
same as select * from table01 where name ="A";

【在 s***s 的大作中提到】
: SQL里select有什么办法ignore case么?
: Thx!

avatar
s*s
3
what part? what do u mean?
我就是要search database,但是希望search的时侯ignore case,
不关大写小写,指要字母一样就可以选中。
我在用sqlplus,要怎么设?

【在 a****s 的大作中提到】
: What part do you want to ignore? In mysql, if I define a field like char(5),
: the case are ignored. select * from table01 where name ="a"; is the
: same as select * from table01 where name ="A";

avatar
a*s
4
In mysql, you can use text(or blob, I forgot which one) to define the field
where you want to ignore case.

【在 s***s 的大作中提到】
: what part? what do u mean?
: 我就是要search database,但是希望search的时侯ignore case,
: 不关大写小写,指要字母一样就可以选中。
: 我在用sqlplus,要怎么设?

avatar
xt
5

SQL natually ignores case, as with SQL92

【在 s***s 的大作中提到】
: what part? what do u mean?
: 我就是要search database,但是希望search的时侯ignore case,
: 不关大写小写,指要字母一样就可以选中。
: 我在用sqlplus,要怎么设?

avatar
s*s
6
ft
at least that's not true for this sqlplus

【在 xt 的大作中提到】
:
: SQL natually ignores case, as with SQL92

avatar
xt
7

In this case, you can convert everything into uppercase. dont know
hwo to do it.

【在 s***s 的大作中提到】
: ft
: at least that's not true for this sqlplus

avatar
m*t
8
Usually in server settings you can set case sensitive or insensitive.
I know you can do this on SQL Server, Sybase, and Oracle(not 100% sure
for this one). Check out your server settings bah.

【在 s***s 的大作中提到】
: ft
: at least that's not true for this sqlplus

avatar
s*f
9
不知道你解决了没有
你用sqlplus那么应该是oracle的
有一个办法是把比较的双方转为小写, 比如
SELECT id, name FROM EMP WHERE lower(NAME) = lower('Socks');
I saw another solution for Oracle. But I didn't pay attention
because the above is enough for my applications.

【在 s***s 的大作中提到】
: SQL里select有什么办法ignore case么?
: Thx!

avatar
b*e
10
I set btitle and ttitle
so every page has the title,
how to delete the title now?
avatar
p*e
11

Don't understand your question

【在 b***e 的大作中提到】
: I set btitle and ttitle
: so every page has the title,
: how to delete the title now?

avatar
b*e
12
do u know the command of btitle and ttitle?
they set title in the bottom or top of one page,
but after I set it,
every page has its title.
now want to cancel the title,
what can I do then?
thanks

【在 p*****e 的大作中提到】
:
: Don't understand your question

avatar
W*S
13
set them to " "

【在 b***e 的大作中提到】
: do u know the command of btitle and ttitle?
: they set title in the bottom or top of one page,
: but after I set it,
: every page has its title.
: now want to cancel the title,
: what can I do then?
: thanks

avatar
a*i
14
say I have a table
create table test
(
id int,
name text
);
how do I get the names of the biggest 10 ids?
Thanks!
avatar
D*N
15
hehe.. if it's MSSQL you can always
SELECT text
FROM test
WHERE id IN
(SELECT TOP 10 id
FROM test)

【在 a*****i 的大作中提到】
: say I have a table
: create table test
: (
: id int,
: name text
: );
: how do I get the names of the biggest 10 ids?
: Thanks!

avatar
b*e
16
select top 10 id from test order by id desc

【在 a*****i 的大作中提到】
: say I have a table
: create table test
: (
: id int,
: name text
: );
: how do I get the names of the biggest 10 ids?
: Thanks!

avatar
a*i
17
This is what I am using now on postgresql:
select id from test order by name limit 10;
I posted the question on the newsgroup last night and got 5 answers this morning.
相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。