Hello, "Z",
Have you made sure you don't have a trailing space or other invisible
character at the end of the field?
As a first step, you might try a query such as the following:
* select '(' || LocationID || ')' , * from airports where
LocationID like 'USE%'*
Maybe this helps,
Donald Griggs
On Tue, Apr 2, 2013 at 7:54 PM, Support <apps...@gmail.com> wrote:
> Hi
> I have a database which has an entry "USE" in a table called airports with
> column LocationID.
> When I call
> sqlite3 -line ~/Desktop/maps.db 'select * from airports where LocationID
> like "USE%";'
> I get correct result.
>
> But when I call
> sqlite3 -line ~/Desktop/maps.db 'select * from airports where
> LocationID=="USE";'
>
> I do not get any result.
>
> When I call
> sqlite3 -line ~/Desktop/maps.db 'select LocationID from airports;'
>
> I do see that "USE" is in there among many other entries.
>
> It only happens with "USE". Does not happen with "BOS" etc.
>
> Thanks
> Z
> ______________________________**_________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
