'where column's all words exist into Search String

there is a table :- "my_table" this table has 1 column :- "place"

this table has many records.

Values of place column:- 1- "Dehradun Uttrakhand" 2- "New Delhi Delhi" 3- "Gurugram Hariyana" 4- "Dehradun" ......

User input "Dehradun, Uttrakhand, India".

Now we need to get record which has word dehradun and uttrakhand. All words from Column must be exist into search string.

  • When user input Dehradun, Uttrakhand. Mysql should return only 1st and 4th record.
  • When user input Dehradun, Delhi. Mysql should return only 4th record.
mysql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions