At 13:43 -0700 5/11/02, impala wrote:
>Thanks for answering
>"search character by character" 11 May 2002
>
>Making use of a HTML textfield which sends text to
>variable 'varLastName'.
>How do I concatenate the variable part('varLastName')
>with
>the % part is it something like:
>
>SELECT LASTNAME, FIRSTNAME,
>DEPARTMENT FROM EMPLOYEES WHERE LASTNAME LIKE
>'varLastName'&%
>OR is it something like 'varLastName%' ??Depends on your scripting language, and you haven't mentioned what that is. > >Previous Answer: >Use a SQL pattern and the LIKE operator. For example >"C%" >matches any value beginning with "C". "Wil%" matches >any value beginning with "Wil". > >Some of the other responses you've gotten indicate >that >you should use "%var%", but that will match values >that >contain var anywhere, not just at the beginning. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
