1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

LIKE returning empty

Discussion in 'MySQL' started by Jeremy Benson, Sep 24, 2017.

0
  1. #1
    I've got a simple query returning empty. Usually these work fine. I'm not sure if I'm missing something, or if I just need to re-create the table. This query is being run directly from phpmyadmin.

    SELECT `ID`, `username`, `original`, `originalPoster`, `title`, `type`, `link`, `description`, `hearts`, `reposts`, `datePosted`, `originalToken`, `token` FROM `sleuths` WHERE `title` LIKE '%Something%' ORDER BY `ID` DESC LIMIT 12
    Code (markup):
    I've tire lowercase 's' as well in something. Nothing is returning.

    I have three entries with title "Something Cool"
     
    Jeremy Benson, Sep 24, 2017 IP