View Single Post
  #7 (permalink)  
Old 06-28-04, 08:03 AM
sumogray sumogray is offline
Newbie Coder
 
Join Date: May 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
The only way i could figure to do it was to split the searches... so i now have 2 seperate searches, one by person one by company - i had to also resort back to LIKE statements, because i need to use wildcards, and i dont think you can using FULLTEXT

Code:
SELECT * FROM contacts WHERE (contact_name) LIKE ('%$keyword%') OR
							(department) LIKE ('%$keyword%') OR
							(job_title) LIKE ('%$keyword%')
Reply With Quote