Search the Community
Showing results for tags 'mysql ignore white space'.
Found 1 result
-
Hi All, I am uisng PHP & Mysql DB for my site and i have a task for suggesting Categories based on User keyword input. I have written the query as below but i need to ignore white spaces of the values of columns while matching, how can we achieve it SELECT search.*, MATCH (name) AGAINST ('black' IN BOOLEAN MODE) AS name_match, MATCH (keywords) AGAINST ('black' IN BOOLEAN MODE) AS keyword_match, MATCH (description) AGAINST ('black' IN BOOLEAN MODE) AS description_match FROM search WHERE MATCH (name, keywords, description) AGAINST ('black' IN BOOLEAN MODE) ORDER BY (name_match * 3 + keyword_match * 2 + description_match) DESC LIMIT 0,100; I tried using replace() which were throwing error SELECT search.*, MATCH (replace(`name`,' ','')) AGAINST ('black' IN BOOLEAN MODE) AS name_match, MATCH (replace(`keywords`,' ','')) AGAINST ('black' IN BOOLEAN MODE) AS keyword_match, MATCH (replace(`description`,' ','')) AGAINST ('black' IN BOOLEAN MODE) AS description_match FROM search WHERE MATCH (name, keywords, description) AGAINST ('black' IN BOOLEAN MODE) ORDER BY (name_match * 3 + keyword_match * 2 + description_match) DESC LIMIT 0,100;
