iam trying to search for a word from two fields in one table . for example :
i want search for "camel" in both fields .How can i do that?.
i tryed this one but it didn't work...
SELECT topic_title & ' ' & topic_txt as fulltxt FROM topic where fulltxt LIKE '$keyword'