Hi
Try this.
select * from table where upper(text) like upper('%dog%')
Then all words with 'dog' in it, will appears in your query.
Hope this helps
/Frank
I'm working on a full text search that will search through subject
lines. The search word is not necessarily a discreet word but
beginning. Is there a switch
to the RPM to force placement of the database on a different file system?
Submitter-Id: [EMAIL PROTECTED]
Originator:MySQL server
Organization:
MySQL support: none
Synopsis: mysqld won't start after installation
Severity: non-critical
Priority: low
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:MySQL server
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class
password: NO)'
This occurs whether I am root or mysql (user).
Can you assist?
You can contact me at [EMAIL PROTECTED]
/scott
Hoo-Repeat:
Install
Fix:
Submitter-Id: [EMAIL PROTECTED]
Originator:MySQL server
Organization: Nortel Networks
Synopsis: Can't connect
Hy!
I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36.
It works fine with some databases I created with 36.
But I copied some databases from 29 and I get this
mysql use lumina;
Didn't find any fields in table 'absences'
Didn't find any fields in table 'admins'
Didn't find
On Thu, 5 Apr 2001, Gerald Clark wrote:
I forgot to mention that the permisions are already set to mysql:mysql
660
MySQL Server wrote:
Hy!
I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36.
It works fine with some databases I created with 36.
But I copied some