But also consider, if you don't want to ask for
select
subject,subhead,subsubhead,data2,data3,see_also
from npl_detail
where (subject like '% asia %'
AND NOT subject like '%winter%')
OR
cut
ORDER BY
subject, subhead,
--- Werner Stürenburg [EMAIL PROTECTED] wrote:
Calvin Xu schrieb am Donnerstag, 23. August 2001,
03:16:09:
select
subject,subhead,subsubhead,data2,data3,see_also
from npl_detail where ( (subject like '% asia %'
OR
subhead like '% asia %' OR subsubhead like '% asia
%'
or data2
Hello there,
I couldn't send email out from my mysql server so I
couldn't use mysqlbug to report the problem. I am
trying to enter the information in the mysqlbug
format:
Description:
The following sql statement couldn't return me
results:
select
Calvin Xu schrieb am Donnerstag, 23. August 2001, 03:16:09:
select subject,subhead,subsubhead,data2,data3,see_also
from npl_detail where ( (subject like '% asia %' OR
subhead like '% asia %' OR subsubhead like '% asia %'
or data2 like '% asia %' or data3 like '% asia %' or
see_also like