Re: Partial and inexact matches

SELECT FROM WHERE LIKE '%' the % is a wildcard and will match up anything after the chars. you can also put one infront to match ANYTHING with in it. ---8>< Many thanks for taking time to answer an "easy" qu

Re: Partial and inexact matches

SELECT FROM WHERE LIKE '%' the % is a wildcard and will match up anything after the chars. you can also put one infront to match ANYTHING with in it. hth Tim "Computers are like Air-con, open windows and they stop working!" Robert S wrote: Probably a real n00b question. I am writing a simple co

Partial and inexact matches

Probably a real n00b question. I am writing a simple contact management database with MySQL (version 3.23.49-8.9, Debian Woody). I'd like users to be able to enter the first few characters of a contact's name to do a search, and I'd like the option of doing inexact matches or phonetic matches.

Hebrew

Using 4.1 Though I had it cracked ? I created a new table and set the Charset to Hebrew and the field  Collation to hebrew_general_ci  I then uploaded data to the database using MS Acess (with an ODBC connection) In MSAccess on my PC the Hebrew comes through fine. However when I open the newly

Re: BINARY LIKE '..' just does not work

On Saturday, March 05, 2005 1:46 PM [GMT+1=CET], Gleb Paharenko <[EMAIL PROTECTED]> wrote: Hello. The problem I think is in indexes. After dropping the unique key the query gives the correct result. I've reported a bug: http://bugs.mysql.com/bug.php?id=8976 You may add your comments there. I have

Re: Which file to backup

Yes , I'm using innodb. Is it necesary to do a mysqladmin flush-logs before making a copy of ib_logfile* or must the server go down to do a safe copy of the ib_logfiles ? thanks Mauricio On Fri, 2004-09-17 at 09:08, Egor Egorov wrote: > Mauricio Pellegrini <[EMAIL PROTECTED]> wrote: > > > I'

Re: Illegal mix of collations - new twist on a familiar problem...

Hello. Please, send us an output of the following statements: show variables like '%char%'; show variables like '%collation%'; "Stembridge, Michael" <[EMAIL PROTECTED]> wrote: > When running this simple query: > SELECT fileid FROM test WHERE ecn='0' > > > MySQL yields

Re: Logging failed attempts

Hello. You may use the General Query Log. See: http://dev.mysql.com/doc/mysql/en/query-log.html MrExecutive <[EMAIL PROTECTED]> wrote: > Hello Guys, > > I am using mySQL 4.1 for windows. How do i go about logging all failed > login attempts? > > Thanks! > > -- For

Re: BINARY LIKE '..' just does not work

Hello. The problem I think is in indexes. After dropping the unique key the query gives the correct result. I've reported a bug: http://bugs.mysql.com/bug.php?id=8976 You may add your comments there. "Artem Kuchin" <[EMAIL PROTECTED]> wrote: > MySQL: 4.1.8a > OS: FreeBSD 5.3

RE: insert data

Michael, John, ALL; Thank you! Thanks you! My errors of "local_host" and "if $dbh->err" fix it. I am able to insert and select data. Thank you ALL, Jerry -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Friday, March 04, 2005 5:41 PM To: John Trammell Cc: mysql@