Re: Full text search
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 could be
> a fragment like ...
>
> dog where dog could appear as hotdog, doggone, dognapper etc.
>
> My question is, is there a way of wildcarding the search request to look
> for word fragments.
>
> I can see in the MySql manual that a search parameter like dog* will
> look for any word ending in dog.. but that is not sufficient for this
> case.
>
> Anyone know to do this, or if it is possible?
>
> Thanks
> Gord
>
>
>
>
> _
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql@lists.mysql.com
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: MySQL server >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.22.32 (Source distribution) >Environment: System: Linux mhn.kansai.nttcom.co.jp 2.2.18-1 #1 Wed Jan 17 20:25:02 JST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-pc-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O6 -fomit-frame-pointer' CXX='g++' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --host=i686-pc-linux-gnu --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A newbie is having troubles starting mysqld on a new installation of version 4.01
>Description: I think that when I installed mysql, I ran out of room on the /var file system >How-To-Repeat: bash-2.05$ /usr/sbin/mysqld --datadir=/home/mysql InnoDB: Error: data file ./ibdata1 is of different size InnoDB: than specified in the .cnf file! InnoDB: Could not open data files 020630 1:55:08 Can't init databases bash-2.05$ ls /home/mysql angel.err ibdata1 mysql mysql.sock test bash-2.05$ ls /home/mysql_safe --datadir=/home/mysql ls: unrecognized option `--datadir=/home/mysql' Try `ls --help' for more information. bash-2.05$ /usr/bin/mysql_safe --datadir=/home/mysql bash: /usr/bin/mysql_safe: No such file or directory bash-2.05$ /usr/bin/mysqld_safe --datadir=/home/mysql Starting mysqld daemon with databases from /home/mysql 020630 01:56:20 mysqld ended bash-2.05$ >Fix: The installation RPM should test that the filesystems have enough 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 installation >Severity: non-critical >Priority: low >Category: mysql >Class: change-request >Release: mysql-4.0.1-alpha (Official MySQL RPM) >Environment: Linux angel 2.4.7-10 #1 Thu Sep 6 17:21:28 EDT 2001 i586 unknown bash-2.05$ df -hl FilesystemSize Used Avail Use% Mounted on /dev/hda4 2.8G 1.6G 1.0G 60% / /dev/hda1 11M 2.7M 8.1M 25% /boot none 19M 0 18M 0% /dev/shm /dev/hda3 95M 70M 20M 78% /var /dev/hdb1 18G 13G 5.4G 70% /home /dev/cdrom595M 596M 0 100% /mnt/cdrom bash-2.05$ rpm -q redhat-release redhat-release-7.2-1 System: Linux angel 2.4.7-10 #1 Thu Sep 6 17:21:28 EDT 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Dec 16 2001 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x1 root root 5716491 Sep 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem connecting to db after installation on linux 7.1
Description: I've installed mysql on my linux 7.1 server (via RPMS) and it self-configured. It is now running however I can not connect to it. I keep getting the followingn error message: mysqladmin: connect to server 'localhost' failed error: 'Access denied for user: '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: Nortel Networks >Synopsis: Can't connect to database >Severity: critical >Priority: high >Category: mysql >Class: support >Release: mysql-3.23.39 (Official MySQL RPM) >Environment: System: Linux toolbox 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 19 12:20 /lib/libc.so.6 -> libc-2.2.2.so -rwxr-xr-x2 root root 1236396 Apr 6 17:58 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 15:27 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 15:27 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem migrating from 3.23.29 to 3.23.36
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 any fields in table 'classes' Didn't find any fields in table 'marks' Didn't find any fields in table 'students' Didn't find any fields in table 'teachers' Didn't find any fields in table 'users' Didn't find any fields in table 'vars' Database changed mysql> select * from users; ERROR 1017: Can't find file: './lumina/users.frm' (errno: 13) And the files exist and worked under 29. Tell what do I have to do. Thanx! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem migrating from 3.23.29 to 3.23.36
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 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 any fields in table 'classes' > > Didn't find any fields in table 'marks' > > Didn't find any fields in table 'students' > > Didn't find any fields in table 'teachers' > > Didn't find any fields in table 'users' > > Didn't find any fields in table 'vars' > > Database changed > > > > mysql> select * from users; > > ERROR 1017: Can't find file: './lumina/users.frm' (errno: 13) > > > > And the files exist and worked under 29. > > > > Tell what do I have to do. > > > > Thanx! > > > Change the ownership and permissions on the databases/files to allow > mysqld to read them. > > When you copied them, you were not the user mysql. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can user change own password?
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 password. Is this possible? Edward Burr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
