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 bu
nough free space
before 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 install
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator: MySQL server
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
27;root@localhost' (Using 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:
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 datab
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 an
Hello,
I am trying to figure out how to allow a MySQL user
to change his own password. So far, the absolute
minimum access I have been able to grant the user is
to change anyone's password (using the columns_priv
table). I want the user to be able to change his own
password, but only his own pass
