MySQL full text search in admin
|Reported by:||simon29||Owned by:||nobody|
|Has patch:||yes||Needs documentation:||yes|
|Needs tests:||yes||Patch needs improvement:||no|
Full text search hasn't been implemented properly in admin. The query is being word split and OR'd like regular fields.
Attached patch fixes this, allowing you to type in any mysql boolean search.
Simply prefix your admin search_fields with @ to use, eg ('@myfield', ).
Be sure to include ALL the fields you have included in your index, else mysql might not use the full text index and instead default back to running a standard LIKE query.
BTW, I can't recall the various search_field operators mentioned in docs?
Change History (9)
Changed 5 years ago by simon29
comment:1 Changed 5 years ago by simon29
- Needs documentation unset
- Needs tests unset
- Patch needs improvement unset