When do search query how to break the word?
For example
Product Title
Field title
Autumn and winter new large size ladies loose sweater jacket female cardigan thickened midi wool
Product Reviews
Field Content
Autumn and winter indoor wear comfortable, go out with cotton feather vest also fashionable occasional. A-type skirt pendulum style, can block the waist belly fat. Shoulder bearing gravity is worth upgrading in the weaving design. The circumference of the sleeve cage is narrow and thin, the sleeve length is short, and the materials are shabby compared with the rich. The interior can only be worn with a sleeveless or thin shirt. I 159cm,135g,103cm bust, 39cm shoulder width, 35cm arm circumference, for reference. Very worried about the shrinkage, lest the baby is "a water coat."
Search Large Size wool coat
Search for large size wool comfort models
How do you do that? What I started thinking is to take out the keyword a word '% '. $wd. '% '? That's not going to happen when a few words come together.
------to solve the idea----------------------
MySQL provides regular expression retrieval, why not?
$word = ' Large size wool coat ';
$word = preg_replace ('/\s+/', '
------to solve the idea----------------------
', Trim ($word));
$sql = "SELECT * from Tbl_name where concat (title,content) REGEXP ' $word '";
It is much more efficient to use third-party full-text search drivers if conditions permit.
