I need your help for MSQL

Discussion in 'MySQL' started by phpsolution, Apr 23, 2012.

0
  1. #1
    This is database structure :
    http://sqlzoo.net/movie.htm

    I need query for this problem "List all of the Star Trek movies, include the id title and yr. (All of these movies include the words Star Trek in the title.)"

    thanks
     
    Solved! View solution.
    phpsolution, Apr 23, 2012 IP
  2. phpsolution

    phpsolution Active Member

    Messages:
    449
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    90
    #2
    I think query should be like this "SELECT id , title , yr from movie WHERE title like = 'Star Trek%'"
     
    phpsolution, Apr 23, 2012 IP
  3. #3
    This should work:
    SELECT id, title, yt FROM movie WHERE title LIKE 'Star Trek%'
     
    Arttu, Apr 24, 2012 IP