-Original Message-
From: VenuGopal Papasani [mailto:[EMAIL PROTECTED]
Sent: Monday, March 13, 2006 10:33
To: mysql@lists.mysql.com
Subject: Help regarding a simple query
Hi,
I am searching for a query where i can have pattern
matching without considering the cases.You can
Now i need to get all the records which consists of the string
venu(case should not be considered either case should be).i.e i should get
1,2,3,4,5,8 records
A simple way is ...
...
WHERE LOCATE('venu', col_name ) 0
...
or if the column is [VAR]BINARY, LOCATE('venu',CAST(col_name AS
-Original Message-
From: VenuGopal Papasani [mailto:[EMAIL PROTECTED]
Sent: Monday, March 13, 2006 11:48
To: Jeff
Subject: Re: Help regarding a simple query
Hi Jeff,
This is venu again.Last mail i did not include a constraint that is
what irritating me most.Actually if i got venu-kkk
SELECT * from hwu_articles WHERE id = '$id' and price is not null and name
is not null and ratings is not null;
Bhavin.
- Original Message -
From: Alex Behrens [EMAIL PROTECTED]
To: MYSQL [EMAIL PROTECTED]
Sent: Friday, August 02, 2002 4:49 PM
Subject: help with a simple query..
Hi
I have 2 tables:
bases, and properties
base has a ZIPCODE field in the table, as does the properties table.
I'm trying to find all bases that do NOT have a property in that zip code.
What I've tried is:
The general answer:
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_10_0
In your case,
Try this. I couldn't find if MYSQL supports not in's so I followed there
outer joins. You can read up on in in the mysql manual, do a search on
outer joins.
select base.zipcode,properties.zipcode from base right join properties on
base.zipcode=properties.zipcode where base.zipcode is null;
On