OpenEuphoria

Re: Quick EuSQL Question (Matt?)

• Posted by Matt Lewis <matthewwalkerlewis at gmail.com> Apr 14, 2006
• 585 views

cklester wrote:
> 
> Is there a search provision in EuSQL? That is, if I want to search for a term
> in a particular record's field data, can I do it? :)
> 
> I envision something like:
> 
>   all_recs = sql_find(DB_NAME, TEXT_TO_FIND, FIELD_NAME_TO_SEARCH)
> 
> and all_recs contains all the records matching the find.
> 
> If not, when can you get that done for me? :)

You mean like:

all_recs = run_sql( "select * from my_table where my_field like '*" &
                    TEXT_TO_FIND & "*'" )

Matt Lewis