MySQL advanced Query how to

[phpdevil]

Hi,

How can we build a simple query search engine from a mysql database?
I have tested simple query with var=$query. However, when we have strings such as "Topic Floor", if there is no "Topic Floor" together in the field, the result will be NULL. How can we make it return all rows with "Topic" or "Floor" or "Topic Floor"???

[Bjom]

take a looksee at the like operator

have a read about indexing, the use of indexes and why in turn like will produce slow queries, too(which is no issue unless the query runs often)

[johanafm]

And there is also match ... against