sql选择查询多个不完整的单词

Question

need help for my problem...

i have a record on my database where it contains multiple words in 1 row.

example:

product_name:

white sugar big
brown sugar big
white sugar small
brown sugar small

now... i made a select query that able to select products even not complete word. i use 'like' here.

select * from products where prod_name like '%".$pname."%' 

note: $pname is a php varriable...

so i tried to query the word "whi"

then the result are:

white sugar big
white sugar small

now my problem is i want to make my search flexible that if i search the word "whi bi"

the result would be"

white sugar big....

thnx in adavance =)

Answer 1

Just replace every whitespace with a % in your php variable before building the query.