one question on SQL# Database - 数据库
r*e
1 楼
in SQL standard, if I want to search a table based on an attribute
A1(varchar(100)), I can use
SELECT * FROM TABLE1 WHERE A1=somthing;
if I try to select the records which have at least 3 words in A1, what's the
SQL command?
I tried
SELECT * FROM TABLE1 WHERE A1 LIKE '% % %';
but it does not work, anyone knows the answer?
Actually it is a exercise in Ullman's book: database system: the complete
book, Exercise 6.1.4 f).
Thanks in advance!
A1(varchar(100)), I can use
SELECT * FROM TABLE1 WHERE A1=somthing;
if I try to select the records which have at least 3 words in A1, what's the
SQL command?
I tried
SELECT * FROM TABLE1 WHERE A1 LIKE '% % %';
but it does not work, anyone knows the answer?
Actually it is a exercise in Ullman's book: database system: the complete
book, Exercise 6.1.4 f).
Thanks in advance!
