> | But I have a question: is there any difference between the following?
> | SELECT lname, fname FROM contacts WHERE lname = 'smith';
> | SELECT lname, fname FROM contacts WHERE lname LIKE 'smith';
> | Sincerely,
> | -Josh
> My
> gut hunch is that if your LIKE expression is going to contain no
w
| Hi All,
|
| From what I understand the LIKE keyword allows you to do things like
include
| wildcards and match against regular expressions.
|
| But I have a question: is there any difference between the following?
|
| SELECT lname, fname FROM contacts WHERE lname = 'smith';
| SELECT lname, fname
I should have included the context of this question when I originally asked
it, but I'll include it here now with my apologies:
The reason I am asking is because I have a search method in a PHP class that
searchs a table based on a specific field. By way of example, you would do
something like
Hi Joshua, all!
Am Di, den 08.02.2005 schrieb Joshua Beall um 17:18:
> Hi All,
>
> >From what I understand the LIKE keyword allows you to do things like include
> wildcards and match against regular expressions.
>
> But I have a question: is there any difference between the following?
>
> SEL
Joshua Beall wrote:
Hi All,
From what I understand the LIKE keyword allows you to do things like include
wildcards and match against regular expressions.
But I have a question: is there any difference between the following?
SELECT lname, fname FROM contacts WHERE lname = 'smith';
SELECT lname, fna
