String Search problem - PHP with MySQL

Discussion in 'PHP' started by Tim Smith, Jun 4, 2008.

  1. #1
    Dear all,
    I am using MySQL.

    One of my column database contains strings in non-English language, like "Nguyễn Văn", etc. (latin_swedish_ci collation)

    I use PHP search box to search for that string in database. If I enter exact string "Nguyễn Văn" into search box, I get the result, no problem.

    My problem is ....how if I don't want to type exact string (annoying for my members), but only "Nguyen Van", and I get the result ?


    Thank you very much for advice.

    Tim
     
    Tim Smith, Jun 4, 2008 IP