basicly it needs to search through a mysql table for a certain word or set of words. im not fully sure how to do that tho. so i have a coujlpe ideas but need more info.
1. with a myslq query like "SELECT (column) FROM (table) WHERE (column) (operator) (value)" if i put a single word in there and the cell in the table itself contains more than a single word. will it search through that cell for that word or look for a cell that specifically has that word and only that word in it?
2. i started thinking farther into it and came across a built in string function that i thought might have some possibilities to it. the function is "substr_count()" lets use an example of the function in use before i ask my question.
Code: Select all
echo substr_count("Hello world. The world is nice","world");
Code: Select all
2
3 is there a built in string function that will go through a string and return if it found the search keywords in the string itself or not.
4 is there a built in string function that i can use to split a string such as "hello world" into an array that would look something like this
Code: Select all
array (
0 = "hello"
1 = "world"
)
any help would be awesome guys! (and girls? lol)