Ron Wallace wrote:
> thanks, helpers, but I think I have a simple solution:
> I will insert a space at the front of the string,
> where the db must accept and retain it.
>
> BTW, here is the SQL I am working with:
> //
> elseif ($desc==desc) {
> $sql="
I think the other replies to this are missing the point.
You want to search a text field for the word Wash, and want to put the space in so you
can search with the space, eliminating words which begin with wash. But then, if you
think about it, that means you'd have to search for commas, and fu
Ron
I do believe that placing a space in '%$var %' will do the same as a
varchar and sprip it off the end. Not positive. However I believe
something like this will do the trick:
SELECT something
FROM a_file
WHERE replace(CONCAT_WS('','.',a_file.field,'.'),' ','.') LIKE '%.$var.%'
HTH... Dan
Ron