The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql Case Search

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

  1. jaymc

    jaymc Well-Known Member

    Joined:
    Jan 5, 2005
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    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
     
Loading...

Share This Page