MySQL search for a
===

I need to implement a search in mysql table for a certain word to find in a specific column (type: text). <br>

I thought that the easiest way is to do:
    
    $str = "something"; # let's say passed by POST or GET from a form
    $sql = "select lala, textThing from table_name where dudu=1 and textThing LIKE %'$str'%";

This seems to work just fine if doing query manually in mysql, but not on php through web.
It throws 
    <blockquote>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%searchedString%' at line 1</blockquote> 

where searchedString is, well, you know, the string I searched for :)

First PHP looks like this:

    $str = NULL;
	

    echo "<p>Search for a string</p>";
	echo "<form name='formSearch' action='result.php' method='post'>";
	echo "<input type='text' name='text' size='30'/>";
	echo "<input type='submit' name='search' value='Search'/>";
	echo "</form>";
	
The second one is just getting the "text" and doing mysql and supposed to show the data

  