LIKE検索について

Jan 30, 2008

AD:

今までの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."%'))";

AD:

Cloud Nine

No Comments, Comment or Ping

Reply to “LIKE検索について”

Warning: Undefined variable $user_ID in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/themes/grid_focus_public_mizo/comments.php on line 66

You must be logged in to post a comment.