On Sun, 2 Nov 2003 00:06:46 +0100, you wrote:
>if($bok==1)
>{$query = "select compno,thCompany from main_company where thCompany LIKE
>'%0123456789%'";}
>
>I have looked in the DB and i see quite a few companies have a number in the
>beginning, but still this returns me no rows....any ideas why?
That query is looking for any record where thCompany includes the text
"0123456789" at any point. Compare
"LIKE '1%'"
and read the chapter on string comparison functions in the MySQL manual.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
