> Xuanvinh Vu <[EMAIL PROTECTED]> wrote:
>> I have search google but have not found a solution. I have a field
>> called Name and I want to select the rows that have Name starts with
>> certain string. How could I do this?
>
> select * from tableName where Name LIKE 'xyz%';
>
> Igor Tandetnik
I would add that it seems from Xuanvinh's post that he is looking for
names that start with '2_'.
Since LIKE considers '_' to be a metacharacter that matches any single
character, wouldn't the '_' need to be escaped? Something like this:
select * from tableName where Name LIKE '2/_%' ESCAPE '/';
- Richard Klein
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
