Search one word in record field??? - Yoeri De Bruyn - com.mysql.lists.win32

3 messages in com.mysql.lists.win32Search one word in record field???

From	Sent On	Attachments
Yoeri De Bruyn	25 Oct 2000 04:58
Kostas M Kutrakis	25 Oct 2000 10:10
Joel Fentin	25 Oct 2000 12:25

Subject:	Search one word in record field???
From:	Yoeri De Bruyn (yoer...@multicap.be)
Date:	10/25/2000 04:58:41 AM
List:	com.mysql.lists.win32

Hi!

I have a database with one table like follows:

URL_ID | URL_LINK | PAGE_INOF | PAGE_CONTENT

The PAGE_CONTENT contains the entier content of one website page. PROB: I want to look e.g. for the word "homepage" in the fields of the PAGE_CONTENT column. So I'm not looking for an exact phrase. Since "SELECT PAGE_CONTENT FROM My_Table WHERE My_Table.PAGE_CONTENT="homepage" looks for the exact phrase I can't use this syntax.

Any body a clue on how to work this out?

Thanks for any helpful trick or hint! Yoeri.