i need to make application which should search for some phrases inside specific mysql table. I need it to support all bells and whistles like google does (AND/OR keywords, quotes, words match)
You should write a query with all conditions for all needed fields included.
Also you can use the TCustomMyDataSet.FilterSQL property.
You can find more detailed information about this in the MyDAC help.