update where 'contains $text'

[juschillinnow]

can you do this?

$cut = "hello how are you doing today, this very fine day?"
$text = "hello how are you doing";
$update = "update storeProduct set productDescription = '$cut' where productID = '$name' and productDescription contains '$text'";

is there a way to something like this?

[tomhath]

productDescription like '%$text%'

[PHPdev]

You can do something like that, but you run the risk of updating more than one record... Not sure if that is what you are looking for or not...

Thanks

PHPdev