accent sensitivity in fulltext search
Hi, How can I have accent sensitive, case insensitive fulltext query? version: 5.0.45 The database, tables, connection, data etc. are all utf8. select name from people where match(name) against ('königsberger' in boolean mode); shouldn't return konigsberger. Any idea, collation? Regards Salam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: accent sensitivity in fulltext search
Thanks Santino, but unfortunately didn't help . I tried utf8_bin, just for checking, same results¸ Not even the case sensitivity is respected. The following queries return the same results: select name from people where match(name) against ('königsberger' in boolean mode); select name from people where match(name) against ('koNigsberger' in boolean mode); Königsberger konigsberger Could it be a version dependent problem? Regards Salam On Mon, 2009-02-16 at 20:26 +0100, Santino wrote: Hi, try to set the collation to utf8_unicode_ci. I have had the inverse problem and I solved with utf8_general_ci. Santino At 19:33 +0100 16-02-2009, Salam Baker Shanawa wrote: Hi, How can I have accent sensitive, case insensitive fulltext query? version: 5.0.45 The database, tables, connection, data etc. are all utf8. select name from people where match(name) against ('königsberger' in boolean mode); shouldn't return konigsberger. Any idea, collation? Regards Salam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=santino.cusim...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL/PHP ?
Hi Ted, 1. Modify the query which presents all records by selecting let's say the peopleID. 2. When you build your update link you can use that ID to ask for a particular record. 3. Then you can use the same query + AND peopleID=THE_ID_OF_THAT_RECORD_EXTRACTED_FROM_THE_LINK. something like this: ALL RECORDS: SELECT peopleID, firstName, lastName, deptPOS, workPH, homePH, location, model, make, propID, addressIP, OS FROM people, make, models, machines WHERE people.peopleID = machines.peopleID AND make.makeID = models.makeID AND models.modelID = machines.modelID; PARTICULAR RECORD: SELECT peopleID, firstName, lastName, deptPOS, workPH, homePH, location, model, make, propID, addressIP, OS FROM people, make, models, machines WHERE people.peopleID = machines.peopleID AND make.makeID = models.makeID AND models.modelID = machines.modelID AND peopleID=THE_ID_OF_THAT_RECORD_EXTRACTED_FROM_THE_LINK; regards Salam [EMAIL PROTECTED] wrote: I'm writing here in hopes of finding someone who uses this and might be able to help me. I am dealing with a recordset who's query is thus: SELECT firstName, lastName, deptPOS, workPH, homePH, location, model, make, propID, addressIP, OS FROM people, make, models, machines WHERE people.peopleID = machines.peopleID AND make.makeID = models.makeID AND models.modelID = machines.modelID; My tables and keys are: table 1) people - primary key = peopleID table 2) make - primary key = makeID table 3) models - primary key = modelID - foreign key = make ID table 4) machines - primary key = machinesID - foreign keys = peopleID, modelID The above query (using Dreamweaver MX speak) is a repeating region behavior so that I get a master PHP page in web browser that displays all my records with the fields as I wish them (using the data from the 4 tables), that works fine --thanks all. At the end of each row (record) on that master page I am building 2 links: Update and Delete. The Update link will lead to a detail page of that particular record, identical visually to the particular record in the master page except that it will be presented in an editable/submit form -that will update the record in the database. Right now my problem is how to adjust the recordset query -above- to produce the result that will give that specific record/row that the link is next to. Right now I have the link working but I am using the same query as above and I am not getting the row that is next to the link, i.e., I'm not getting the correct record -but some other record. If anyone on this list has any knowledge and could help get over this hurdle I would be EXTREMELY grateful -been trying to figure this out for days. I apologize in advance for posting this here if that was wrong. I won't do again, I'm just looking for some help. I have several books and have been to other forums and the internet... still working on it. Thanks, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL/PHP ?
[EMAIL PROTECTED] wrote: Thanks Salam, but a question: this would mean that I must do by hand every record ID link, no? I don't think you are building your master html page by hand, do you? No, of course no hand work. The script should take care of it e.g. in a loop while fetching the records from the 1st query to be presented (each record will have it's own peopleID) you have to add something like this to the url which will be then read by the update script. yourUpdateScript?id=$peopleID Salam On Sunday, June 29, 2003, at 02:29 AM, Salam Baker Shanawa wrote: Hi Ted, 1. Modify the query which presents all records by selecting let's say the peopleID. 2. When you build your update link you can use that ID to ask for a particular record. 3. Then you can use the same query + AND peopleID=THE_ID_OF_THAT_RECORD_EXTRACTED_FROM_THE_LINK. something like this: ALL RECORDS: SELECT peopleID, firstName, lastName, deptPOS, workPH, homePH, location, model, make, propID, addressIP, OS FROM people, make, models, machines WHERE people.peopleID = machines.peopleID AND make.makeID = models.makeID AND models.modelID = machines.modelID; PARTICULAR RECORD: SELECT peopleID, firstName, lastName, deptPOS, workPH, homePH, location, model, make, propID, addressIP, OS FROM people, make, models, machines WHERE people.peopleID = machines.peopleID AND make.makeID = models.makeID AND models.modelID = machines.modelID AND peopleID=THE_ID_OF_THAT_RECORD_EXTRACTED_FROM_THE_LINK; regards Salam [EMAIL PROTECTED] wrote: I'm writing here in hopes of finding someone who uses this and might be able to help me. I am dealing with a recordset who's query is thus: SELECT firstName, lastName, deptPOS, workPH, homePH, location, model, make, propID, addressIP, OS FROM people, make, models, machines WHERE people.peopleID = machines.peopleID AND make.makeID = models.makeID AND models.modelID = machines.modelID; My tables and keys are: table 1) people - primary key = peopleID table 2) make - primary key = makeID table 3) models - primary key = modelID - foreign key = make ID table 4) machines - primary key = machinesID - foreign keys = peopleID, modelID The above query (using Dreamweaver MX speak) is a repeating region behavior so that I get a master PHP page in web browser that displays all my records with the fields as I wish them (using the data from the 4 tables), that works fine --thanks all. At the end of each row (record) on that master page I am building 2 links: Update and Delete. The Update link will lead to a detail page of that particular record, identical visually to the particular record in the master page except that it will be presented in an editable/submit form -that will update the record in the database. Right now my problem is how to adjust the recordset query -above- to produce the result that will give that specific record/row that the link is next to. Right now I have the link working but I am using the same query as above and I am not getting the row that is next to the link, i.e., I'm not getting the correct record -but some other record. If anyone on this list has any knowledge and could help get over this hurdle I would be EXTREMELY grateful -been trying to figure this out for days. I apologize in advance for posting this here if that was wrong. I won't do again, I'm just looking for some help. I have several books and have been to other forums and the internet... still working on it. Thanks, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't seem to use a different datadir....
If you haven't done this: run mysql_install_db to create the privilege tables db, host, user in mysql directory below the new directory. The script 'll create the test directories too. Regards Salam [EMAIL PROTECTED] wrote: Hi. Anyone know the trick to successfully using a different directory for database files? I've tried changing my.cnf and also using the command line option. When I run mysqld_safe it says it's using the new directory but then writes mysqld ended and quits. Mysql never comes up. I changed owner and group of the new directory and files to be mysql. What can be going wrong? It just doesn't seem to work! Thanks!! - 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
Re: Help with SQL statement?
Try this: SELECT * FROM MyTable WHERE RefList not regexp (^|[^0-9])MyNum([^0-9]|$); Regards Salam Jeff Snoxell wrote: Hi, I've got a varchar field in a mysql table that contains 'N' numbers (each a maximum of 4 digits, not zero padded) separated by spaces when more than 1 number is present. eg. field content might be any of the following '' '123 4567 1234 45 3' '3' '3 4 6' I want to select only those records that do not contain a certain number. Problem I have with using LIKE %MyNum% is that obviously this is going to match 3 against 123 which I don't want it to. Is there something I can use like Perl's word boundary pattern match code? My statement so far is: SELECT * FROM MyTable WHERE RefList NOT RLIKE \bMyNum\b # Where \b is a word boundary Many thanks, Jeff - 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
Re: Using Perl DBI quote() method with NULL values?
Hi Jeff, Try the magic undef as it is with no '' or $dbh-do('insert into yourtab values (' . join (',', map($dbh-quote($_), $your_stuff, undef, $more_stuff)) . ')') ; Regards Salam Jeff Snoxell wrote: Hello, I've got a mysql table with a lot of fields and I'm using a map statement to pass each of my values for a new record through the quote system so-as to have everything nicely wrapped up. Problem is that I can't find any way of writing a null value to my DB when the value has first passed through quote(). I've tried: my $err = $MyDatabase-do('INSERT INTO MyTable VALUES(' . join(,,map($MyDatabase-quote($_), 0, # REF 0, # PARENT REF $FormData{'Title'} . . $FormData{'Name'} . , $FormData{'Email'} . , \N, # -- I REALLY WANT THIS TO BE A NULL VALUE! etc., etc., etc. )) . ')'); Which works fine except the \N isn't entered into my database as a null value. I've also tried '\N' and '' and . Any ideas how I can solve this easily? Thanks, Jeff - 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
Re: Full text search
Hi, As of Version 4.0.1 you can use the truncation operator * in boolean mode: select firstname from contacts where match(firstname,lastname) against ('steff*' in boolean mode); This will match steff , steffa, steffan, steffane, steffans But of course not stef unless you use 'stef*' . Regards Salam Steffan A. Cline wrote: Am I missing something on mysql full text search? I was using a simple statement like select firstname from contacts where match(firstname,lastname) against ('steffa'); I am actually looking for steffan but wanted to see what it would return. Now, if I search for the full name steffan it finds it ok. Is there something I am missing for it to return any matches containing steff or steffa or even stef Thanks Steffan --- T E L 6 0 2 . 5 7 9 . 4 2 3 0 | F A X 6 0 2 . 9 7 1 . 1 6 9 4 Steffan A. Cline [EMAIL PROTECTED] Phoenix, Az http://www.ExecuChoice.net USA AIM : SteffanC ICQ : 57234309 The Executive's Choice in Lasso driven Internet Applications --- - 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
Re: Bug using truncation in 4.0.4-beta
Hello Victoria, Is there any plan to make operators work with phrase searches. something like: against ('comput* scie*') in boolean mode I have tested 4.0.6-gamma and I can see that the bug is fixed: Empty set is returned when truncation operator is used :-) Regards Salam Victoria Reznichenko wrote: sbs, Tuesday, October 29, 2002, 7:31:03 AM, you wrote: samdldlds Description: samdldlds Special case: using SELECT with truncation doesn't return some records samdldlds when the searched query appears at the end of the line. Note that the last record will samdldlds be matched and returned because there is a space character at the end. samdldlds I am using ft_min_word_len = 1; Currently phrase search doesn't work with operators. If they work for somebody, it's a bug, too :-) - 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
Truncation problem or bug in 4.0.4-beta (linux)
Hello, I need un explanation to the following, or it is a bug which needs a fix. mysql select ti from article where match (ti) against ('computer science' in boolean mode) ; . 21 rows in set (0.07 sec) Now using the truncation operator * mysql select ti from article where match (ti) against ('computer science*' in boolean mode); 18 rows in set (0.06 sec) Expected at least 21 records to be returned. 3 are missing. I found out that no record will be returned if the term computer science appears at the end of the title. These are the 3 missing records: ## Phase transition in a random fragmentation problem with applications to computer science ## A Collection of Papers and Memoirs Celebrating the Contribution of Rod Burstall to Advances in Computer Science ## KITE microprocessor and CAE for computer science Regards Salam - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php