I think you should do this SELECT DISTINCT id FROM table WHERE col_1 ilike '^[search]' OR col_2 ilike '^[search]' ORDER BY col_1
to obtain your expected result. and this will only show the id in suggest list. i think this will help you. Enjoy suman -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-Search-several-database-columns-at-the-same-time-with-the-same-search-field-tp4025500p4025531.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck® Code Sight™ - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users