dbTalk Databases Forums  

LIKE Question

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss LIKE Question in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mtek
 
Posts: n/a

Default LIKE Question - 08-26-2008 , 02:41 PM







MySQL has this function, was wondering if this can be done with
Oracle.

Basically a query which uses the LIKE method, but is able to rank the
results in relevance, which ones match the most to the fewest??


Reply With Quote
  #2  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: LIKE Question - 08-26-2008 , 02:50 PM






On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <mtek (AT) mtekusa (DOT) com>
wrote:

Quote:
MySQL has this function, was wondering if this can be done with
Oracle.

Basically a query which uses the LIKE method, but is able to rank the
results in relevance, which ones match the most to the fewest??
You shouldn't assume any knowledge of MySQL in this forum.
You also should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course.
You should post an example of the results of the LIKE function in
MySQL.
However, above all, you should stop being a bore!!!

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #3  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: LIKE Question - 08-26-2008 , 02:50 PM



On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <mtek (AT) mtekusa (DOT) com>
wrote:

Quote:
MySQL has this function, was wondering if this can be done with
Oracle.

Basically a query which uses the LIKE method, but is able to rank the
results in relevance, which ones match the most to the fewest??
You shouldn't assume any knowledge of MySQL in this forum.
You also should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course.
You should post an example of the results of the LIKE function in
MySQL.
However, above all, you should stop being a bore!!!

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #4  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: LIKE Question - 08-26-2008 , 02:50 PM



On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <mtek (AT) mtekusa (DOT) com>
wrote:

Quote:
MySQL has this function, was wondering if this can be done with
Oracle.

Basically a query which uses the LIKE method, but is able to rank the
results in relevance, which ones match the most to the fewest??
You shouldn't assume any knowledge of MySQL in this forum.
You also should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course.
You should post an example of the results of the LIKE function in
MySQL.
However, above all, you should stop being a bore!!!

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #5  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: LIKE Question - 08-26-2008 , 02:50 PM



On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <mtek (AT) mtekusa (DOT) com>
wrote:

Quote:
MySQL has this function, was wondering if this can be done with
Oracle.

Basically a query which uses the LIKE method, but is able to rank the
results in relevance, which ones match the most to the fewest??
You shouldn't assume any knowledge of MySQL in this forum.
You also should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course.
You should post an example of the results of the LIKE function in
MySQL.
However, above all, you should stop being a bore!!!

--
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #6  
Old   
Mtek
 
Posts: n/a

Default Re: LIKE Question - 08-26-2008 , 03:01 PM



On Aug 26, 2:50 pm, sybra... (AT) hccnet (DOT) nl wrote:
Quote:
On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <m... (AT) mtekusa (DOT) com
wrote:



MySQL has this function, was wondering if this can be done with
Oracle.

Basically a query which uses the LIKE method, but is able to rank the
results in relevance, which ones match the most to the fewest??

You shouldn't assume any knowledge of MySQL in this forum.
You also should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course.
You should post an example of the results of the LIKE function in
MySQL.
However, above all, you should stop being a bore!!!

--
Sybrand Bakker
Senior Oracle DBA
Seems like your wonderful personality just follows you everywhere. Go
play in the middle of the expressway with the rest of your kind.


Reply With Quote
  #7  
Old   
Mtek
 
Posts: n/a

Default Re: LIKE Question - 08-26-2008 , 03:01 PM



On Aug 26, 2:50 pm, sybra... (AT) hccnet (DOT) nl wrote:
Quote:
On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <m... (AT) mtekusa (DOT) com
wrote:



MySQL has this function, was wondering if this can be done with
Oracle.

Basically a query which uses the LIKE method, but is able to rank the
results in relevance, which ones match the most to the fewest??

You shouldn't assume any knowledge of MySQL in this forum.
You also should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course.
You should post an example of the results of the LIKE function in
MySQL.
However, above all, you should stop being a bore!!!

--
Sybrand Bakker
Senior Oracle DBA
Seems like your wonderful personality just follows you everywhere. Go
play in the middle of the expressway with the rest of your kind.


Reply With Quote
  #8  
Old   
Mtek
 
Posts: n/a

Default Re: LIKE Question - 08-26-2008 , 03:01 PM



On Aug 26, 2:50 pm, sybra... (AT) hccnet (DOT) nl wrote:
Quote:
On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <m... (AT) mtekusa (DOT) com
wrote:



MySQL has this function, was wondering if this can be done with
Oracle.

Basically a query which uses the LIKE method, but is able to rank the
results in relevance, which ones match the most to the fewest??

You shouldn't assume any knowledge of MySQL in this forum.
You also should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course.
You should post an example of the results of the LIKE function in
MySQL.
However, above all, you should stop being a bore!!!

--
Sybrand Bakker
Senior Oracle DBA
Seems like your wonderful personality just follows you everywhere. Go
play in the middle of the expressway with the rest of your kind.


Reply With Quote
  #9  
Old   
Mtek
 
Posts: n/a

Default Re: LIKE Question - 08-26-2008 , 03:01 PM



On Aug 26, 2:50 pm, sybra... (AT) hccnet (DOT) nl wrote:
Quote:
On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <m... (AT) mtekusa (DOT) com
wrote:



MySQL has this function, was wondering if this can be done with
Oracle.

Basically a query which uses the LIKE method, but is able to rank the
results in relevance, which ones match the most to the fewest??

You shouldn't assume any knowledge of MySQL in this forum.
You also should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course.
You should post an example of the results of the LIKE function in
MySQL.
However, above all, you should stop being a bore!!!

--
Sybrand Bakker
Senior Oracle DBA
Seems like your wonderful personality just follows you everywhere. Go
play in the middle of the expressway with the rest of your kind.


Reply With Quote
  #10  
Old   
joel garry
 
Posts: n/a

Default Re: LIKE Question - 08-26-2008 , 04:05 PM



On Aug 26, 1:01*pm, Mtek <m... (AT) mtekusa (DOT) com> wrote:
Quote:
On Aug 26, 2:50 pm, sybra... (AT) hccnet (DOT) nl wrote:





On Tue, 26 Aug 2008 12:41:08 -0700 (PDT), Mtek <m... (AT) mtekusa (DOT) com
wrote:

MySQL has this function, was wondering if this can be done with
Oracle.

Basically a query which uses the LIKE method, but is able to rank the
results in relevance, which ones match the most to the fewest??

You shouldn't assume any knowledge of MySQL in this forum.
You also should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course.
You should post an example of the results of the LIKE function in
MySQL.
However, above all, you should stop being a bore!!!

--
Sybrand Bakker
Senior Oracle DBA

Seems like your wonderful personality just follows you everywhere. *Go
play in the middle of the expressway with the rest of your kind.
You might try going to http://tahiti.oracle.com and typing in:
oracle text

You shouldn't assume any knowledge of MySQL in this forum. You also
should stop treating this forum and
news:comp.databases.oracle.server as a replacement for reading the
official Oracle documentation and as a free Oracle course. You should
post an example of the results of the LIKE function in MySQL.

However, above all, you should stop being a bore!!!

Apologies to Sybrand for any copyright violation.

jg
--
@home.com is bogus.
Who's accessing your database? http://www.signonsandiego.com/uniont..._1b26scam.html



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.