adding truncation operator to mysql query

[adnan1983]

Trying to add boolean operators to the mysql query, but the truncate operator doesn't seem to work. Query works fine, but turns results without truncate features. Can anyone tell me why?

$query_search_info = "$query_search_info = "SELECT
								goo.foo,
								goo1.foo1,
								goo2.foo2,
						  MATCH 
						  		(goo1.foo1)
						  AGAINST 
						  		('($search_criteria)*' IN BOOLEAN MODE)
						  AS 
						  		score
						  FROM 
								tablename
	                      WHERE 
						  MATCH
						  		(goo1.foo1)
						  AGAINST 
						  		('($search_criteria)*' IN BOOLEAN MODE)
						  HAVING
						  		score > 0.2
						  ORDER BY
						  		score
						  DESC";

[LarsLai]

hi!
why is it '($search_criteria)' and not just '$search_criteria' as the asterisk has to be appended to the word?