LIKE検索について

Ayumi

17 years ago

今までのLIKE検索の仕方

(  company LIKE '%".$word."%' OR  address LIKE '%".$word."%' OR  owner LIKE '%".$word."%'  OR   url LIKE '%".$word."%' OR  title LIKE  %".$word."%')";

1	( company LIKE '%".$word."%' OR address LIKE '%".$word."%' OR owner LIKE '%".$word."%' OR url LIKE '%".$word."%' OR title LIKE %".$word."%')";

　↓
こうすればよかったんですね。

(company ||  address || owner ||  url || title  ILIKE ('%".$value."%'))";

1	(company \|\| address \|\| owner \|\| url \|\| title ILIKE ('%".$value."%'))";