Well I have a part of a form where it asks the user "what technology do you use" and it has 18 check boxes (sigh). So I thought I'll just mash them all together using a # or ! in between them like... "Apple iPod#Laptop Computer" then throw them in 1 field and not make 18 more columns. Now I'm woundering how do I search a field for "laptop" with out pulling every single field down using explode('#',$array['tech']) and throwing the matched in an array in php, how can i do it in the query :confused:


Thank you.

You could use % wildcard.


$query = "SELECT * FROM table WHERE tech LIKE '%Apple ipod%'";

You could use % wildcard.


$query = "SELECT * FROM table WHERE tech LIKE '%Apple ipod%'";



Of course, <bonks head>, Thank you.