Help : search for a word and its number
| From: | Adi Wibowo | Date: | Wed, 01 May 2002 06:13:38 +0000 |
| Subject: | Help : search for a word and its number | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18919@lists.php.net to get a copy of this message | ||
Hi, I need a favour from you guys 'n girls :
If I have records like this
ID Content
1 "John have a red book, and a yellow book. He give a yellow book to Tina".
2 "Luke doesn't have any book at all, he always borrow it from John".
3 "John like swimming".
Can I search this records (table) for a word "book" and also number of "book" occurences at every record?
From table above, the result would be
ID Number
1 3 2 1I use Oracle 8.1.7. Thanks, Adi