Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    24

    Unanswered: Fetching text from phrase

    http://img182.imageshack.us/img182/5120/tablesqlnp4.gif

    i can query for zodehala like following

    PHP Code:
    SELECT `title` , `message` , `touserarray`
    FROM `pmtext`
    WHERE `fromusername` = 'zodehala' 
    How can i query for joe? (see pic.)

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    consider using a fulltext index on the relevant column and use the MySQL clause Match Against or the LIKE clause with the appropriate wild cards % eg where <mycolumnname> like ("%joe%")
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •