By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,968 Members | 1,843 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,968 IT Pros & Developers. It's quick & easy.

which database is best for match querying

P: n/a
hi all

im wondering is there a better db than mysql for perfoming queries to
search textfields for the occurence of a string value? for example does
oracle have greater functionality is this regard?

Jul 8 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On 8 Jul 2006 15:27:47 -0700, "monomaniac21" <mc******@googlemail.comwrote:
>im wondering is there a better db than mysql for perfoming queries to
search textfields for the occurence of a string value? for example does
oracle have greater functionality is this regard?
This would be better asked on a database newsgroup, it's offtopic here.

Yes, Oracle does have more powerful fulltext searching - look up Oracle Text.
Of course, you pay a little more for Oracle.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Jul 8 '06 #2

P: n/a
On Sat, 08 Jul 2006 23:32:57 +0100, Andy Hassall wrote:
Yes, Oracle does have more powerful fulltext searching - look up Oracle Text.
Of course, you pay a little more for Oracle.
Not necessarily. OracleXE is free as in free beer. It depends no the size
of your database. In this case size does matter.

--
http://www.mgogala.com

Jul 8 '06 #3

P: n/a
On Sat, 08 Jul 2006 23:11:22 GMT, Mladen Gogala <go****@sbcglobal.netwrote:
>On Sat, 08 Jul 2006 23:32:57 +0100, Andy Hassall wrote:
>Yes, Oracle does have more powerful fulltext searching - look up Oracle Text.
Of course, you pay a little more for Oracle.

Not necessarily. OracleXE is free as in free beer. It depends no the size
of your database. In this case size does matter.
The OP didn't specify the amount of data, but yes I'd forgotten about XE.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Jul 8 '06 #4

P: n/a

monomaniac21 wrote:
hi all

im wondering is there a better db than mysql for perfoming queries to
search textfields for the occurence of a string value? for example does
oracle have greater functionality is this regard?
MS SQLServer is quite good. It does full text indexing.

Jul 9 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.