string matching function in mysql

Question

I've to match a string with strings in a column of mysql table, i need to select the strings which has more than 80% of match. is there any function in mysql will do this?

for example "quote by placing" string matches more than 80% for the string"quote by place". Like this i've filter.

Thanks!

Do you have a special reason for "80%"? can you give us some background on what you're doing — Ben G
– Ben G, Commented Jun 9, 2011 at 7:04

Ben G · Accepted Answer · 2011-06-09 07:03:19Z

3

A FULLTEXT search would probably be the best approach for what you're doing. No need to pick an arbitrary % otherwise.

If you're doing more intensive searching check out some of the engines like Sphinx

answered Jun 9, 2011 at 7:03

Ben G

26.9k35 gold badges112 silver badges177 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

vkGunasekaran Over a year ago

i think the best way is using 'like' and match 80% for the result what i get. is it correct.

vkGunasekaran Over a year ago

By using similar_text($str1,$str2,$match) function on search results will give some optimum result i wanted, correct?

Ben G Over a year ago

Yes, you can use PHP functions like that to analyze your results for the exact % match

k102 · Accepted Answer · 2011-06-09 07:01:36Z

0

try chopping 20% of a string in php and then use like for 80% of your string and all strings to compare

answered Jun 9, 2011 at 7:01

k102

8,1099 gold badges52 silver badges72 bronze badges

4 Comments

Ben G Over a year ago

I might be wrong, but I think he wants 80% that appears anywhere, not just the start. So cutting it would only compare a certain 80% that you pick

vkGunasekaran Over a year ago

@babonk yes, i just want to match 80% anywhere on the string not the start

k102 Over a year ago

oh, so i'm sorry for misunderstanding the question

vkGunasekaran Over a year ago

@banonk i want to some options to be selected by default on the basis of this match.

Shaun Hare · Accepted Answer · 2011-06-09 07:13:36Z

0

You could try looking at the MYSQL soundex function that may give you what you need

answered Jun 9, 2011 at 7:13

Shaun Hare

3,8712 gold badges26 silver badges36 bronze badges

Comments

0xCAFEBABE · Accepted Answer · 2011-06-09 07:15:43Z

0

As far as I understand your criteria, you want a fuzzy search. This is not implemented in MySQL. You will have to find a way to externalize the check for this.

answered Jun 9, 2011 at 7:15

0xCAFEBABE

5,6765 gold badges40 silver badges60 bronze badges

Collectives™ on Stack Overflow

string matching function in mysql

4 Answers 4

3 Comments

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related