Mixxx

Make library search keyword-search instead of phrase-search

Bug #644963 reported by Peter K
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mixxx
Fix Released
Wishlist
Owen Williams
Mixxx 1.9.0

Bug Description

Currently, when one searches, two words, Mixxx searches for those two words RIGHT NEXT TO EACH OTHER. It would be more intuitive if the search feature worked more like google or itunes, etc., where, one would type "words in quotes" to find that exact phrase. Also, being able to search parts of an artist's name and part of a song name would be a huge plus.

Example: I'm trying to find the song called "Break My Bank", by New Bois.

Say I had forgotten the exact name.

So currently, if I typed: 'break bank' into the search nothing would come up. The same would go for 'bank new', etc.

Additionally,
Please change the search feature or allow this as an option in preferences! Thank you. *Wishlist*

See original description
Peter K (peterklingelhofer)
description: updated
RJ Skerry-Ryan (rryan)
Changed in mixxx:
status: New → Confirmed
importance: Undecided → Wishlist
tags: added: library search
RJ Skerry-Ryan (rryan)
summary: - Improving the search function
+ Make search work like Google
tags: added: weekend
RJ Skerry-Ryan (rryan)
summary: - Make search work like Google
+ Make library search keyword-search instead of phrase-search
tags: added: easy
Revision history for this message
Sean M. Pappalardo (pegasus-renegadetech) wrote :

Isn't this just a matter of changing the SQL statement to use the ~* or LIKE operator?

Revision history for this message
RJ Skerry-Ryan (rryan) wrote :

Fixed in Owen's features_library branch.

Changed in mixxx:
assignee: nobody → Owen Williams (ywwg)
milestone: none → 1.9.0
status: Confirmed → Fix Committed
Revision history for this message
RJ Skerry-Ryan (rryan) wrote :

Sean: we already use LIKE, but we do it like `FIELD LIKE "%SEARCHTERM%"', which ends up finding exactly the phrase SEARCHTERM. It isn't hard though, you just split on spaces and add a LIKE '%WORD' for every word in the phrase. Owen's already got it covered though.

Revision history for this message
RJ Skerry-Ryan (rryan) wrote :

err. '%WORD%'

RJ Skerry-Ryan (rryan)
Changed in mixxx:
status: Fix Committed → Fix Released
Revision history for this message
Swiftb0y (swiftb0y) wrote :

Mixxx now uses GitHub for bug tracking. This bug has been migrated to:
https://github.com/mixxxdj/mixxx/issues/5536

lock status: Metadata changes locked and limited to project staff
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.