How do i select nearest value

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rajiv07
    New Member
    • Jun 2007
    • 141

    #1

    How do i select nearest value

    Hi Experts,

    I want to get a nearest matching value for my input string.Is any function paticular function for this operation.

    Ex:
    ----

    My input string : Expert.

    suppose my database table has these values 1)Exprt, 2)data, 3)some

    Here the output will be---->Exprt.

    Is any Idea Please.

    Thanks in advance.
  • mwasif
    Recognized Expert Contributor
    • Jul 2006
    • 802

    #2
    Use SOUNDS LIKE

    [CODE=mysql]SELECT * FROM table_name WHERE column_name SOUNDS LIKE 'expert';[/CODE]

    Comment

    Working...