I think I need to take the text that someone put in a web form and then break it up so I can search for any one of those words in a SQL statment. I need help in how to get sql to go though that and put them all together in one query? Any idea?
This is what I have now and I know it is not even close:
SELECT distinct list_company, List_state, list_address_1, LIST_CITY, LIST_PHONE_1, LIST_EMAIL
FROM master_list, category where master_list.list_company like '%#advfind#%' or master_list.List_state like '%#advfind#%' or master_list.List_address_1 like '%#advfind#%' order by List_Company