MySQL Forums
Forum List  »  PHP

Re: Maybe Hard select
Posted by: Rupak Pasari
Date: April 08, 2006 08:18AM

Try this,

Select W.id, W.word, D.definition From WORDS W, DEFINITIONS D Where W.word Like '%soa%' And D.id=W.id Group By W.id, W.word, D.definition Order By W.word


Here, you could replace soa in the like query with a variable (eg, $search, where $search='soa')


Best of luck,
Rupak

Options: ReplyQuote


Subject
Written By
Posted
April 07, 2006 03:33AM
April 07, 2006 09:37AM
Re: Maybe Hard select
April 08, 2006 08:18AM
April 08, 2006 10:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.