Select value from database with php where condition value is similar to input

Question

I was wondering....is it possible to retrieve a value from a mysql database if the value of the WHERE statement is similar to the input text? Something like the similar_text() function but applied to the search condition.

Example:

 <?php
   $res = mysqli_query(*CONECTION*,"SELECT value FROM table WHERE condition=*is similar to x*");
  ?>

If this thing is possible please tell me how.

Use [`LIKE`](http://beginner-sql-tutorial.com/sql-like-in-operators.htm) --- [`full-text indexes`](http://www.tuxradar.com/practicalphp/9/3/18) could also be an option. — Funk Forty Niner, Nov 02 '13 at 16:32

score 0 · Accepted Answer · edited May 23 '17 at 10:32

0

You need make use of the LIKE keyword

SELECT value FROM table WHERE condition like %x%

EDIT :

Seems like you are for levenshtein algorithm. Have a look here and here.
StackOverflow Thread

edited May 23 '17 at 10:32

Community

1
1

answered Nov 02 '13 at 16:26

Shankar Narayana Damodaran

68,075
43
96
126

can i specify how similar should the 2 values be? – SpiderLinked Nov 02 '13 at 16:28
`LIKE` does not test similarity. From the docs: "Pattern matching using SQL simple regular expression comparison" – just lerning Nov 02 '13 at 16:29
Or `like %x` or `like x%` ;-) – Funk Forty Niner Nov 02 '13 at 16:31
Thank you for your quick response. I will do the rest of the research on my own :) – SpiderLinked Nov 02 '13 at 16:31

score 0 · Answer 2 · answered Nov 02 '13 at 16:51

0

SELECT value, MATCH(value) AGAINST('x' IN BOOLEAN MODE) AS similarIndex
FROM table WHERE MATCH(value) AGAINST ('x' IN BOOLEAN MODE) 
ORDER BY similarIndex DESC

answered Nov 02 '13 at 16:51

Select value from database with php where condition value is similar to input

2 Answers2