Using BLOBS and TEXT data types in sql statements

[Carlos René Ponce Novelo]

hi, i need to know if i can use blobs or text data types (tiny,medium or long with blob or text) in sql statements. For instance: suppose i have a blob field with large information and i need to find a word in this field. It's valid do this:

<?php
$query = "SELECT * FROM MyTable WHERE MyBLOBField like '%$MyVar%' ORDER BY XField";
$result = mysql_query($query);
//The rest of the statements.
?>

Thanks for your help... bye...