On Tuesday 05 July 2005 05:31 pm, Tom Shaw wrote:
> Is there an easy way to perform a search on VARCHAR/CHAR/TEXT column
> for those entries that has strings that are longer than x without
> writing my own comparitor? I am using SQLite in a PHP environment, I
> am looking for an intrinsic function that would run natively rather
> than a interpretive PHP function to preform this comparison.
checkout the length('string') function.
select * from table where length(a) > length(b);
>
> All help is appreciated,
>
> Tom
