(no subject)

[bigbird]

Hi William,

Sorry, I hit send before I had finished the email - full email  
following.

I have experimented with "LIKE  '%hat'" etc, the trouble is that it  
will also find 'tHAT'.

If some SQLite guru can explain how to do a search like that, I would  
be very pleased.

Cheers

Greg Olson-Hyde
Sydney Australia

RB 2007r5 Pro, Mac OS X 10.4.11



On 19.04.2008, at 10:52pm, william humphrey wrote:
> Are you using a search like:
>
> SELECT * FROM table_name WHERE search_word LIKE  '%hat'
>
>
> this would eliminate "hatter"
>
>
> you can also do 'hat'
>
>
> Use SQLitemanager to experiment with your SQL
>
>
>
> -- Then use Valentina Studio with the same database and SQL  
> searches and
> compare the time it takes.
>
>
>
>
> On Sat, Apr 19, 2008 at 8:45 AM, bigbird <greg at hawkmount.com> wrote:
>
>> Hi,
>>
>> I am currently using RB 2007r5 and the built in SQLite db - I have  
>> struck
>> a problem and need to know if Valentina is a solution.
>>
>> The things I need to know about Valentina are:
>>
>>        1. I have a db with 50,000 records - I need to search and  
>> find,
>> say, the word 'HAT' SQLite also finds 'tHAT', 'wHAT' and 'HATter'
>>
>>
>>
>> Cheers
>>
>> Greg Olson-Hyde
>> Sydney Australia
>>
>> RB 2007r5 Pro, Mac OS X 10.4.11
>>
>>
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>
>
>
> -- 
> http://www.bluewatermaritime.com
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina