User Profile

Collapse

Profile Sidebar

Collapse
js1987
js1987
Last Activity: Oct 25 '11, 11:01 AM
Joined: Sep 2 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • js1987
    replied to Having trouble with MyQSL Queries
    If you are searching for Kung Fu Panda, then this query would work:

    strSQL = "SELECT * FROM p_search WHERE sTITLE LIKE '%Kung%' AND
    sTITLE LIKE '%Fu%' AND
    sTITLE LIKE '%Panda%'
    ORDER BY tid DESC LIMIT 100;"

    So you need to replace your spaces in the query by AND <tablename> LIKE '%<word>%'
    See more | Go to post

    Leave a comment:


  • js1987
    replied to MS Access Attachment vs MySQL Blob
    You could try to use a MYSQL manager like SQLyog.
    Connect to the database and load the table. There is a BLOB viewer that you can use to view the emails.
    You can download the trial version from Webyog
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...