Searching for text in a database
Posted: Wed Nov 09, 2005 8:50 pm
How do you search for text/words/sentences in a TEXT field in a database?
Let's say this is a text field (named popularity) in Jimmy's row:
i.e. (this isn't the real thing obviously)
Okay that was confusing.
And if you can't answer that one, at least answer this one: The following code, is it compatible with all browsers and guaranteed to successfully redirect everytime?
Is there some other redirection script compatible with all browsers?
Let's say this is a text field (named popularity) in Jimmy's row:
How would you just return just the number after Sarah?sarah=25, jessie=14, sam=33, kelly=42, joe=7
i.e. (this isn't the real thing obviously)
Code: Select all
mysql_query("SELECT from subscribers where owner='Jimmy', SEARCH for word sarah in 'popularity' field, return the number 25");And if you can't answer that one, at least answer this one: The following code, is it compatible with all browsers and guaranteed to successfully redirect everytime?
Code: Select all
<meta http-equiv=\"refresh\" content=\"3; url=SOME URL\">