Can you search SQL this way?

[Andy Hilton]

Das

I think what Phil is meaning is :

You would simply do a new sql search for whatever got you your list to start with, plus the extra addition of a like (note that depending on the database, ‘ilike’ can also be a case insensitive search) for your column search within that…..

Andy Hilton
Totally Brilliant Software Inc
Phone (US) : (863) 409 4870 
Phone (UK) : 0207 193 8582
Web : www.totallybrilliant.com <http://www.totallybrilliant.com/> 
Helpdesk : http://totallybrilliant.kayako.com
Email : andyh at totallybrilliant.com

> On Oct 22, 2021, at 10:36 AM, Phil (OmnisList) via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Hi Das,
> 
> the string needs quotes...
> field like '%string%'
> 
> A list?
> That is not a SQL object.
> What is that stored as? is it binary? so basically no chance of looking up on that.
> 
> regards
> Phil Potter
> Based in Chester in the UK.
> 
> On 22/10/2021 15:18, Das Goravani wrote:
>> Hello Listers,
>> 
>> I’m wondering about two SQL searches or selects.
>> 
>> One is if you have a large field full of text, and you want to search for a string inside it. Do you use LIKE %sring% ?
>> 
>> And if you have a list, and you want to select on a value in a column, can you do that?
>> 
>> That’s it.
>> 
>> Thanks
>> 
>> Das Goravani
>> _____________________________________________________________
>> Manage your list subscriptions athttp://lists.omnis-dev.com
>> Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com  
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com