Database custom sql select statement |
[eluser]mypmyp[/eluser]
Hello guys, Thank you for replies! Due to the known issues with SOUNDEX, for example 'Brighton' and 'Bristol' will have same phenoms, I decided to use php similar_text() function, because of it has possibility to tune algorithm sensitivity with alikeness percentage. (http://php.net/manual/en/function.similar-text.php) This function finds typos like: tpancfopmepc (SOUNDEX: 'T152') for transformers(SOUNDEX: 'T652')! MS SQL DIFFERENCE will compute value 1 for this example (max is 4). similar_text percentage will be > 40% So, SOUNDEX not a cool approach for a such issue, levenshtein also is far from a good results. Since portal has not a lot of products I can allow myself to do a little sin and select ALL products from the database and process'em in the foreach :-D Do not tell anybody I have found that if I add a field into the database, exactly into this table, I will have ability to fill it with comma separated metaphrases. Could you please advise: 1. how can I access the database and modify it? (phpmyadmin, ssh, admin page... etc) 2. Is it possible to modify database from the administration area? 3. Is it safe to modify database (add 1 varchar field)? Such field would be super cool, because I will be able to use REGEXP expression in the query to select possibly alike products. Thanks in advance. Best regards, mypmyp |
Messages In This Thread |
Database custom sql select statement - by El Forum - 03-02-2011, 07:54 AM
Database custom sql select statement - by El Forum - 03-02-2011, 02:23 PM
Database custom sql select statement - by El Forum - 03-02-2011, 02:51 PM
Database custom sql select statement - by El Forum - 03-03-2011, 01:03 AM
|