Boolean Searching Help Please
Posted: Wed Aug 18, 2004 12:27 am
Hey there!
New to the whole searching thing with MySQL so I thank you all very much..
below is my query and everything seems to work fine except when I through numbers into the equation.
For exmaple
This would completely ignore the numbers and bring up everything that has 'something' in the field including fields containing '3423' The numbers are not stored in their own column.
The columns are varchars no longer then 255 chars and I need them to contain both text and letters. (i say this because I think this is where my problem is) so is there another type i should be using... or is the searching really not as easy as I think....
oh and is possible to do a boolean search where you search for "some" and get results that are "something"
Just as you would do using LIKE \%
Thanks a million guys!!!!!!!!!!!!!!! and gals!!!!!!!!
New to the whole searching thing with MySQL so I thank you all very much..
below is my query and everything seems to work fine except when I through numbers into the equation.
For exmaple
Code: Select all
<?php
$searchfield = "something -3423";
$result = mysql_query("SELECT * FROM t9 WHERE MATCH path, name AGAINST ('$searchfield' IN BOOLEAN MODE)");
?>The columns are varchars no longer then 255 chars and I need them to contain both text and letters. (i say this because I think this is where my problem is) so is there another type i should be using... or is the searching really not as easy as I think....
oh and is possible to do a boolean search where you search for "some" and get results that are "something"
Just as you would do using LIKE \%
Thanks a million guys!!!!!!!!!!!!!!! and gals!!!!!!!!