Hi.
On Mon, Oct 01, 2001 at 12:37:58AM +0800, [EMAIL PROTECTED] wrote:
> On Sun, Sep 30, 2001 at 11:07:37AM -0500, Gunter Leeb wrote:
> > Hi,
> >
> > Consider Name LIKE 'ABC%' finds all names that start with ABC.
> >
> > I am looking for the reverse: I have a string and I am looking for
> > all the records that have a name which is the BEGINNING of this
> > string. As an example: I have 'ABCDE' and I want rows contains
> > 'ABCD' or 'ABC' or just 'A' found.
[...]
>
> untested: SELECT * FROM <table> WHERE <column> LIKE A[<range>]
If I understand you correctly, that would also return "AAAA" which is
not the wanted result.
SELECT * FROM <table> WHERE 'ABCDE' LIKE CONCAT(Name,'%')
should do. It takes each row, appends the joker and tries to match it
against the given value. This returns a row for
'ABCDE' LIKE 'ABC%'
but not for
'ABCDE' LIKE 'AAA%'
But note that this cannot use an index and therefore might be too
slow.
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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