i want to search a string from all fields of a table
for that i try OR keyword
select * from table name where bus_name like '%" + abc + "%' OR bus_type like '%" + abc+ "%' OR contact_person like '%" + abc + "%'
but it is a lengthy process .i want to do it in a shorter way.
give me the right direction.