string matching in mysql and php

From: Date: Thu, 14 Sep 2000 11:45:02 +0000
Subject: string matching in mysql and php
Groups: php.general 
Request: Send a blank email to php-general+get-16752@lists.php.net to get a copy of this message
hi all, how can i search my database for a particular occurence of a string? select * from articles where content like "%anna%" - pulls out everything containing the word anna and the substring anna, but i would like to pull out article where the content contains the word "anna" and not the substring anna. had a look at the REGEXP funtion in the mysql documentation..but i don't think i have got the syntax correct. Can anyone help ? thanks anna _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

« previous php.general (#16752) next »