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]
-----------------------------------------------------------------------------
