"Blue Wave Software" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm having one of those slow brain days. > > I want a partial filter egg. All records where field1 begins with "ABC" > any > body know the where clause to do this. > > In Access it's where field1 = 'ABC*' but I can't find the MYSQL > equivalent, > or isn't there one.
I believe you are looking for the following syntax: SELECT id FROM table WHERE field1 LIKE 'abc%' DanB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
