Kovah/LinkAce

Case-Insensitive Search

Open

#993 opened on Aug 29, 2025

View on GitHub
 (3 comments) (1 reaction) (0 assignees)PHP (1,761 stars) (111 forks)batch import
EnhancementHelp wanted

Description

Summary

Searching in LinkAce appears to be case-sensitive. For example; searching for abc does not return results for links titled ABC01. This behavior has confused some users who expect searches to be case-insensitive by default.

Proposed Solution

  • Implement case-insensitive search by default for the /search page
  • Optionally provide a checkbox to enable case-sensitive search filter if needed.

Contribution

I am willing to implement this feature myself. I’d like to confirm with the maintainer:

  • Should case-insensitive search be the default behavior, with case-sensitive as an optional toggle?
  • Or do you prefer a different approach?

Additional Context

Example scenario:

  • Link: ABC01.com
  • Search query: abc01
  • Current behavior: No results.
  • Desired behavior: ABC01.com should be returned.

Contributor guide

Tech stack
phpsql
Domain
backendsearch
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
needs maintainer response
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Basic PHPSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70
Research direction
The search functionality is implemented in the backend, likely in a controller or repository class. Look for the method handling search queries, possibly in a file like 'SearchController.php' or a model. The change involves modifying the database query to be case insensitive, e.g., using LOWER() on both the column and the search term. Consider using LOWER(column) LIKE LOWER(:query) with wildcards. After implementing, ensure existing tests pass and add a test for case insensitive search. Also, implement an optional toggle for case sensitive search if required.