MySQL full text search in admin
|Reported by:||Simon Litchfield||Owned by:||nobody|
|Cc:||Joseph Gordon||Triage Stage:||Accepted|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||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?