multiple search on mysql

gmarais · 03-08-2004, 06:00 AM

i have a 'customers' table . what will the sqlquery be to do searches on multiple rows within a table. i.e.

given the 'criteria or part of the word that we are searching for' through a html form, i would like to do a search for anything 'like' the criteria given - results posted to screen and the user can select whatever he wants from that.

thanx.

elitecodex · 03-08-2004, 09:40 AM

Im assuming you are looking for something like this:

Code:

<?php
$query = "select * from `customerstable` where fieldone LIKE '%" . $criteria . "%' OR fieldtwo LIKE '%" . $criteria . "%'";
?>

Not sure though...

gmarais · 03-08-2004, 11:15 PM

yip, this looks like it. will give it a try. thanx.

codedv · 03-10-2004, 08:59 AM

You can also use regular expressions for a more powerful search:

Code:

SELECT * FROM data_table WHERE productName REGEXP "(pen)|(pencil)";