assen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 11:29 PM
To: Ian Izzard
Cc: Rocar Peças; [EMAIL PROTECTED]
Subject: Re: Newbie question on Comparing fields in 2 tables?
An equivalent, but slightly simpler, query would be
SELECT sw.pcname, sw.product
FROM software sw, keywor
An equivalent, but slightly simpler, query would be
SELECT sw.pcname, sw.product
FROM software sw, keywords kw
WHERE sw.product RLIKE kw.Searchname
RLIKE is for regular expression pattern matching. Regular expressions,
unlike LIKE patterns, don't have to match the whole string, so there is
Mr. Izzard,
We have these tables:
Table software
- pcname char(..)
- product char(..)
Table keywords
- id int(..)
- seachname char(...)
and you want to pick out the pcname from the software table, where the