Welcome Guest, Not a member yet? Register   Sign In
Database custom sql select statement
#4

[eluser]mypmyp[/eluser]
Hello guys,

Thank you for replies! Smile

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')! Smile
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 Smile

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



Theme © iAndrew 2016 - Forum software by © MyBB