mysql WHERE

[FrEaKmAn]

Hi

is it possible that when I'm exporting data from mysql database, that I show only those lines which have word (product) located somewhere in the text??

[Buzz]

Sure.. you can use LIKE in the where clause.


mysql_query("SELECT * FROM table_name WHERE fieldname LIKE value%");


There are other ways as well. You can use regex and other methods.

http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html