So I have this query but the error is wrong syntax around '%'$txt2',%' - what would I have to change this too please... thanks
What I am looking for in the field is anything that has txt2, with things after it or just txt2 on its own without anything after it. How would I do this please alltogether.
Thanks.

$result = mysql_query("SELECT * FROM table WHERE field LIKE '%'$txt2',%' ORDER BY field ASC") or trigger_error(mysql_error().$sql);

Sorry , looks like i have sold it with

$result = mysql_query("SELECT * FROM table WHERE field LIKE '%$txt2,%' OR field = '$txt2' ORDER BY field ASC") or trigger_error(mysql_error().$sql);