Announcement

Collapse
No announcement yet.

Need help updating an SQL Query

Collapse
X
Collapse
First Prev Next Last
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Need help updating an SQL Query

    This SQL Query used to work, but doesn't now. I wrote it before we upgraded to vBulletin 5.

    Code:
        select title from thread where title like '%...%'; place content to be searched for between %%​
    I'm trying to locate a thread originally posted in 2007. The query is:
    Code:
    select title from thread where title like '%Microsoft office using wine%';
    When I execute it it responds with:

    An error occurred while attempting to execute your query. The following information was returned.
    error number: 1146
    error desc: Table 'kfnDB.thread' doesn't exist​
    The user no longer exists in our forum, but this thread they started still exists, with multiple replies from other users.
    The Linux Community has given me much. I do what I can to return the favor!

    #2
    Code:
    select title from node where title like '%Microsoft office using wine%';
    Buy me a coffeePayPal QR Code
    My Amazon Affiliate Link ​
    Fast vBulletin VPS Host:
    This site is hosted by IONOS

    Comment


      #3
      Thank you!
      The Linux Community has given me much. I do what I can to return the favor!

      Comment

      Latest Posts

      Collapse

      Working...
      X
      Searching...Please wait.
      An unexpected error was returned: 'Your submission could not be processed because you have logged in since the previous page was loaded.

      Please push the back button and reload the previous window.'
      An unexpected error was returned: 'Your submission could not be processed because the token has expired.

      Please push the back button and reload the previous window.'
      An internal error has occurred and the module cannot be displayed.
      There are no results that meet this criteria.
      Search Result for "|||"