Associate
- Joined
- 19 Mar 2005
- Posts
- 569
Just wondering if any of you can help me out with my query to find employees expertise, employees expertise is a text field and I have a search box where you can search for employees with relevant expertise. The problem I am having is employee can have more than one type of expertise either separated by a space, comma, full stop etc. I would like to be able to search for more than one term no matter how it is split up in the expertise e.g. by comma, full stop, space etc
Would like it to catch all of these if the terms shooting passing were entered
The code I currently have is below, this is ok for when i enter "shooting, passing" but not "shooting passing".
Just wondered if anybody could help me redefine my search?
Would like it to catch all of these if the terms shooting passing were entered
- Shooting Passing
- Shooting, Passing
- Shooting and Passing
- Shooting. Passing.
- Shooting; Passing
The code I currently have is below, this is ok for when i enter "shooting, passing" but not "shooting passing".
Code:
$sqlExpertise=mysql_query("SELECT * FROM staff WHERE FIND_IN_SET('$searchValue',expertise)")or die(mysql_error());
Just wondered if anybody could help me redefine my search?