Re: Partial Filtering

2005-08-18 Thread Alec . Cawley 
Blue Wave Software [EMAIL PROTECTED] wrote on 18/08/2005 
15:57:34:

 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.


WHERE field1 LIKE 'ABC%' ;



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Partial Filtering

2005-08-18 Thread Dan Baker 
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]