CODEWITHSUNDEEP
sqlsqlitewildcard
Devid Demetz
Devid Demetz

Reputation: 125

Trying to use Wildcards in SQLite Browser but its not working

i want to display all the names that start with S. so i tried writing this:

select 
     * 
from 
     User 
where 
     name = 'S%';

0 rows returned.

Upvotes: 0

Views: 211

Answers (1)

Stivan
Stivan

Reputation: 1127

select 
     * 
from 
     User 
where 
     name like 'S%';

If you want to read up on how wildcards work: http://www.w3schools.com/sql/sql_wildcards.asp

Upvotes: 1

Related Questions