Searching multiple word in a given column using regular expression in MS SQL server : I want to perform multiple word on particular column. The given search string may be in different order.  For example , I want to search the book name "Harry Potter Dream world "from books table using like operator and regular expression.

I know, using multiple like operator, we can perform operation using below query
"SELECT * FROM TABLE_1 WHERE bookname like 'Harry Potter' or like 'Heaven world'";

In this case, i want to perform this in a single query. Also i tried with FREETEXT options. That wont be useful when i use self-join. Kindly provide me any other alternatives to solve this.

Also can you provide , how to use regular expression to search multiple word in MS SQL. I tried with multiple options. It won't work for me.

Thanks in advance