-
where name like '%...%' not working
I'm working on this database, but somehow I can't get this SQL statement to work:
SELECT *
FROM tabel1
WHERE name like '%super%';
The (test) database contains only one table called 'tabel1'. It has three fields called id, name, number.
id = 1,2,3,4
name = super 1,super,super 2,super number
number = 112,113,114,115
The sql statement doesn't output anything, but the sqlcourse interpreter does make it work.(http://sqlcourse.com/select_answers.html, exercise 6)
Somebody, please help!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|