Re: [pmapper-users] Search several database columns at the same time with the same search field

[Suman <an...@ya...>]

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.