I've been looking for hours for a sample MySQL Query for the stuff below, just couldnt find one :
Say i had a table with a field called "intro". If i wanted to display all the entries with intro=$variable i know how to do that.
But if i want to display all the entries with $variable and other text within intro how would i do that. For example
$variable = "Adelaide"
and i have an entry in the database under the intro field :
"The board of Adelaide City Force Soccer Club....."
or "Adelaide has announced the..."
how do i display anything with "adelaide" in it ?
Say i had a table with a field called "intro". If i wanted to display all the entries with intro=$variable i know how to do that.
But if i want to display all the entries with $variable and other text within intro how would i do that. For example
$variable = "Adelaide"
and i have an entry in the database under the intro field :
"The board of Adelaide City Force Soccer Club....."
or "Adelaide has announced the..."
how do i display anything with "adelaide" in it ?