Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Mysql Case Search

Discussion in 'General Discussion' started by jaymc, Sep 12, 2005.

  1. jaymc

    jaymc Well-Known Member

    Jan 5, 2005
    Likes Received:
    Trophy Points:
    When doin a MYSQL search on a BINARY field

    how can you get it to return an exact match only e.g LIKE 'joe' and have it return all matches for joe regardless of case

    for example JOE JoE joe JOe

    i cant use Like '%joe%' as that would return joseph Joebo etc etc

    Any Ideas

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice