# FMDB WHERE clause

**URL:** <https://forums.kodeco.com/t/fmdb-where-clause/12518>\
**Category:** Swift\
**Created:** [April 6, 2016, 11:28am UTC](https://forums.kodeco.com/t/fmdb-where-clause/12518 "2016-04-06T11:28:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![krbaswe](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/krbaswe/32/24252_2.png) [@krbaswe](https://forums.kodeco.com/u/krbaswe)\
**Post date:** [April 6, 2016, 11:28am UTC](https://forums.kodeco.com/t/fmdb-where-clause/12518/1 "2016-04-06T11:28:09Z")

</div>

Hi

Could not retrieve row with WHERE but I can retrieve all rows. Plz check code.

func retrieveData()  
{  
let contactDB = FMDatabase(path: databasePath as String)

```
    if contactDB.open()
    {                 
        //this shows record not found
        let results: FMResultSet? = contactDB.executeQuery("SELECT * FROM CONTACTS WHERE Id = '005700000045CTkAAM'", withArgumentsInArray: nil)
        
        //this shows all records
        //let results: FMResultSet? = contactDB.executeQuery("SELECT * FROM CONTACTS", withArgumentsInArray: nil)             
        
        if results?.next() == true
        {
             print("results Id \(results?.stringForColumn("Id")), Name \(results?.stringForColumn("Name"))")
        }
        else
        {
             print("retrieveData record not found")
        }
        contactDB.close()
    }
    else
    {
        print("retrieveData contactDB cannot open Error: \(contactDB.lastErrorMessage())")
    }
}

```