Need to Search A String - Helpppp !

[Anon]

Hi,

Ive ben trying to write code that can do the following operation:

1. Retrive the number of rows from a table
2. Select the field in the table holding the string (sequentially)
3. Split the string into seperate words and save them into an array.
4. compare this array with a keyword that the user enters.
5. if the keyword matches, display the string on the page.

I know that there might be a lot of code, but any help will be greatly appreciated.

[Anon]

I am not sure of what you asked. But if you want to know if a word matches a string from a table row, sql provides a magic word : LIKE. You should write something like this :

SELECT my_row FROM my_table WHERE my_row LIKE "%my_key_word%";

don't forget the %, it means "any string"

By YaK(tm) 🙂