Oh I have no idea. I thought LIKE with '%' was a standard, % being the wildcard.
/Jonas On Jan 24, 2008 1:25 PM, Pavel Kosina <[EMAIL PROTECTED]> wrote: > I was still trying "*jup*" .... > Could you show me documentation page, where this is mentioned? > > Pavel Kosina > > > > Jonas Sandman napsal(a): > > > 1. SELECT * FROM some WHERE xyz LIKE '%jup%' > > > > 2. SELECT * FROM SOME WHERE zyx LIKE 'jul%' > > > > should work. > > > > On Jan 24, 2008 12:44 PM, Pavel Kosina <[EMAIL PROTECTED]> wrote: > > > >> Hello, > >> > >> How to do following queries?: > >> > >> 1/ select * from some where xyz CONTAINS "jup" (anywhere in xyz could be > >> text "jup") > >> 2/ select * from some where xyz STARTSWITH "jup" (the xyz starts with > >> "jup") > >> > >> Thank you. > >> > >> > >> -- > >> Pavel Kosina > >> > >> > >> ----------------------------------------------------------------------------- > >> To unsubscribe, send email to [EMAIL PROTECTED] > >> ----------------------------------------------------------------------------- > >> > >> > >> > > > > ----------------------------------------------------------------------------- > > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > > > > > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
