To search all fields, you need to tell it to search each field in turn using OR:
SELECT blahField FROM blahTable WHERE field1 = 'blah' OR field2 = 'blah' OR ... etc
For part of a word: use part of the word and % as a wildcard. Look carefully at what you've got at the moment. It's looking for the whole word: if MMColParam is 'table', you'll be getting results that match 'table' plus any other characters, eg: 'table' 'tables' 'tabletop' but not part of the word eg: 'tab'
To return matches on part of the word, you have to search for part of the word, not the whole word. I hope that makes sense.