If I build a PHP search query on my MySQL database similar to this:
"SELECT DISTINCT object_id,object_title,object_description
WHERE MATCH (object_id,object_title,object_description)
AGAINST ('$keyword_search' IN BOOLEAN MODE)";
will it return both numeric and alpha matched records from the database? In other words, I would like for the following result to be returned if someone types either "11.4" or "geography" in the keyword search field on my Web page.
11.4 Curriculum Guide Standard IIA 5 Themes of Geography
I've tried but it doesn't seem to work.
Thank you.