HI CRAIG,
i'ts possible to use this query with multiple search terms?
query: "select * from TABLENAME where
if(right(SEARCHFIELD,1)='s',left(SEARCHFIELD,lenth(SEARCHFIELD)-1),SEARCHFIE
LD)
like '%SEARCHTEXT%' "
i.e: one user search for: "passaros jogos campos" [in portugueze]
the app is writt
hi,
in perl: [very simple code]
my $stime = time;
prepare();
execute();
fetchall_array_ref();
my $etime = time;
my $ftime = $etime - $stime;
print "Your query took $ftime seconds\n";
stupid filter: sql, query, mysql, db, table, select, insert, update, delete,
join, create, left join, optimi
hello,
mysql doesn't support sub-select yet...maybe in 4.1 ;)
>mysql> select distinct(nexthop) ip from NameRoute
>where OwnerIP='10.0.1.1' and
>nexthop not in (select ip from NameIP where
>OwnerIP='10.0.1.1');
>ERROR 1064: You have an error in your SQL syntax near
>'select ip from NameIP whe
